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

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea

How to convert this array to string
I am having problems converting this array to a string
using print_r($val[1]); I get:
Code: [

Pagination
Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a quer

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

Get ID from Database when Posting with a HTML Form
I have a form I am submitting to a MySql database. Each product has an ID # attached to it that auto

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

radio button reamains checked
Hello i'm trying to keep the state off my radio buttons so it shows which ones where clicked after t

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me