Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Use bind variables in adhoc sql similar to "execute function/procedure"

Ray007Jun 2 2021

Could the same sort of bind variables be implemented for adhoc scripts as when you execute a procedure or function?
Currently, I may write a script that does

update table1 set col = '&new_val' where id = &id;
update table2 set col = '&new_val' where id = &id;

And when I click run, I get prompted for new_val. Then I get prompted for id. Then I get prompted for new_val. Then I get prompted for id. This sucks...

I'd rather write a script that is more like

update table1 set col = :new_val where id = :id;
update table2 set col = :new_val where id = :id;

And get prompted with a single sheet asking me for values to bind to :new_val and :id. Let me choose the datatypes to bind in and set values....

Comments

JPreda

I have the same problem.

It's happend to me when passing more than 1 parameter to the target page and then you press the back button of the browser.

Any suggestions?

Hilary Farrell-Oracle

Hi,

I believe you are hitting bug 25838279, which has been fixed in 5.1.2.  A 5.1.1 Patch Set Exception (PSE) is also available for download from My Oracle Support - on the 'Patches & Updates' tab, search for the bug number 25838279.  Please note that you will need to upgrade your instance to APEX 5.1.1 before attempting to apply the PSE to your instance.

Regards,

Hilary

1 - 2

Post Details

Added on Jun 2 2021
1 comment
86 views