Can you pass the PL/SQL to a stored procedure and use the dbms_sql package
to execute it? I know I've executed simple SQL statements - like truncate
which you can't do right in PL/SQL for some reason - but I don't know how
complex you can do with dbms_sql.
Dan
-----Original Message-----
From: Jeff Britts [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 8:39 AM
To: CF-Talk
Subject: RE: PL/SQL
Basically, we're working on a tool to generate the pl/sql script on the fly
so we
cant use a stored proc. Any ideas?
-----Original Message-----
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:54 AM
To: CF-Talk
Subject: Re: PL/SQL
We use cf and pl/sql stored procs extensively. What exactly are you trying
to do?
Jeff Britts wrote:
> Anyone have any luck running PL/SQL through ColdFusion? The simple stuff
> seems to work ok, but if you throw it something complex it chokes.
>
>
> Jeff Britts
> ColdFusion Engineer
> e-Dialog
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
