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

Weird Problem with curl while sending data
I am facing a weird problem with sending data to a site via curl.

If i send the value by this

ALV grid with 2 headers
Hi Gurus,

I need to display ALV GRID as below.

Header1

PHP Code reffering to database, doing something wrong.. pls help
Well i am quite new with PHP
and for school we have to make a PHP script which reffers to a Data

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

convert PHP array to Javascript array
I have a page that gets a request sent from AJAX, and I am trying to convert a PHP array to a javasc

tag inside php...
hi


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

Uploading Filetypes and placing them in seperate folders.
Hello,

first post , and asking for help im afraid. Very new to PHP, was making good progress

Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.<

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

How do I use a global footer..?
If my index.php has a bole bunch of if functions and exit's in them