Skip to Main Content

SQL & PL/SQL

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!

ora-01008, what is the name of variable?

user12237894Jul 4 2016 — edited Jul 7 2016

Good time of day, Community!

I run several SQL via DBMS_sql package. Each of that SQL has a set of bind variables.

Is there any feature to get a list of variables' names for given SQL?

For instance.

I wonder to get a list of ':name',':result' for the next statement:

select *

  from dual

where :result = :name

With respect!

This post has been answered by Billy Verreynne on Jul 4 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2016
Added on Jul 4 2016
24 comments
3,442 views