HOW to get the bind variables list.

Posted on 16th Feb 2014 07:03 pm by admin

I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need to use DBMS_SQL in order to execute them.
In theese SQL statements I have some bind variables like :NUMORD. (ex. SELECT 'X' FROM YYYY WHERE FIELD_1 = :NUMORD).
I don't know "a priori" names and number of such variables.
Is there any way to have a list of such bind variables ?
I found DBMS_DESCRIBE but is seems to act only on stored procedures/functions.
I know I can tray to inspect the code looking for every ':' but a cleaner solution woulf be appreciated.
Tks

Your Answer:

Login to answer

Other forums

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

Procedural to OOP
John Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pr

values not being entered into table
hi. I;ve created a form, so that when a user enters data into it, it gets added to a table in a data

help connecting a form to php and then emailing the form
Ok. So, I made a form, and I need help to where when submitted, I get an email with the submitted de

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

Web Application Recipe
Hi Guys!

I am working with the Web Application recipes. I am currently working on the sen

Aris, Netweaver BPM, Visual composer and X'app
Dear Experts,

Whats the relationship between the following components: Aris, Netweaver BP