Re: HELP : Substitution SQL Parameters in Forms

If you construct your query into a variable and use DBMS_SQL to parse it you shouldn't have too many problems.

Just remember that dbms_sql cannot be called directly in forms so you may want to create a wrapper function stored on the database which does the call to DBMS_SQL for you.

M

Joao Ricardo B Oliveira wrote in message <7r0kdm$4e9$1_at_pan.ipb.pt>...
>Hi there:
>
> I want to know if there's a way of executing a SQL query in FORMS 4.5
>with a substitution SQL parameter..
>
> for example:
>
> i've a text field in the current record that may contain the follow
>text : '5000,5545,5564'
> i want that when i push a button the follow SQL should be executed:
> select xxx into field_b
> from table
> where id IN '5000,5545,5564'; -- values in the text field
>(varchar2) ...
>
> So, i just want to replace the condition values in the query by the
>field values...
>
> If there's another way of doing it tell me... by forms, by a view or a
>function.. just mail ME please...
>
>--
>------------------------------------------
>- Joao Ricardo B Oliveira jricardo_at_ipb.pt
>-
>- Oracle DBA http://www.ipb.pt/~jricardo
>------------------------------------------
>
>
Received on Mon Sep 06 1999 - 10:42:33 CDT