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

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

Forum tutorial
Im a beginner in PHP. Im making a forum(previous questbook, counter and few others) to learn. For no

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

Expandable Post Code
Hi,

Hope you can help. Which currently I haven't upgraded to connect to a mysql server, so i

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

help finding hacking loopholes
i was attacked by a redirect php injection

my pc is clean of viruses

so i figure that

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

Include a php
Hello,

I'm trying to include a function that shows the recent searches.
Example I have <

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an