In SQL server 7 (and mayber earlier) you can have dynamic sql. You build a
string, then execute it with sp_executesql.
Could this help? I assume there's something like this in pl/sql? Just a
thought.
Mark
[EMAIL PROTECTED]
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
