Execute dynamic query in stored prouder oracle Rdb

Asked Mar 01 '22 at 12:39

Active Mar 01 '22 at 13:57

Viewed 47 times

I want to execute one dynamic update query in oracle rdb through stored procedure.

For example:

Set :updateString='Update table set colum1, column2':

I want to execute :updateString in procedure only.

I have tried below cmds

Exec :updateString
execute :updateString, 
exec sql :updateString

and so on but nothing is working in oracle rdb sql terminal.

I am using Oracle Rdb (a relational database management system for the OpenVMS operating system). Version is Oracle Rdb SQL On Openvms Release 7.4.1.0.0

edited Mar 01 '22 at 13:57

asked Mar 01 '22 at 12:39

Chirag Dhaduk

1

Just to make sure: you're really using Oracle Rdb (a relational database management system for the OpenVMS operating system). Right? – Littlefoot Mar 01 '22 at 12:42
1

Is really `Update table set colum1, column2` valid RDB syntax? Don't you have to assign values to the columns? – jarlh Mar 01 '22 at 12:53
@Littlefoot:Yes – Chirag Dhaduk Mar 01 '22 at 13:13
@jarlh:yes I will assign some values so it is like update table set column1='test1', column2='test2' ; – Chirag Dhaduk Mar 01 '22 at 13:17

Execute dynamic query in stored prouder oracle Rdb

0 Answers0