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

problem with php server update from mid 2009
Hi,

I have this navigation menu on 2 websites which used to work just fine. After a recent up

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

simple script won't work. Please help
I'm new to php, and I am having trouble displaying a simple script in my web browser. My php code ex

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Printing issues with xMII 11.5
For some reason, we have one report (and only one) that is giving us fits when trying to print. The

How to Handle more than one submit button in single form?
Hi
I have one PHP file which contains one Form. In this form there are two Submit type Buttons

delete comma
HI,

How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

Send inserts to mysql thru port 80
Hi!

I have an application that must do some inserts in a mysql db. This db is behind a firewa