Re: Sql Query as an Item formula

Thanks for the info Mark,

I check out the Forms_ddl and Exec_sql, and I'm gonna go with Execute Immediate on the Server Side, due to the fact that with Exec_sql you seem to need to know the columns you will be dealing with to bind your variables and with Execute Immediate I can throw more generic statements at it, it executes faster and with less code to get the results I need.

Thank so much,
--Aaron V

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:7I2dnbVamKKDiUyi4p2dnA_at_comcast.com...
>
> "Aaron V" <Tinkerist_at_hotmail.com> wrote in message
> news:OuWdnebtT7-Ml0yiRVn-hA_at_comcast.com...
> | Thanks Frank,
> | After a bit of frustration in Forms, I think I've got it working now,
> | although not directly in Forms, I don't think Forms supports Execute
> | Immediate (no underscore). I finally put the Function onto the Server
> Side,
> | and then Execute Immediate works, (why is that? can forms not compile
the
> | Dynamic sql?).
> |
>
> forms has its on PL/SQL engine and processes PL/SQL locally, sending
> individual SQL statements to the database
>
> in forms, look into FORMS_DDL or EXEC_SQL
>
> -- mcs
>
>
Received on Fri Dec 12 2003 - 01:05:46 CET