<cfquery ..>
select myFunction(client_id) from dual
</cfquery>
>From this query I get client's name and address & city. I let the database server do most of the work, concatentations, decode(), switch ..whatever.
Nick Han
>>> [EMAIL PROTECTED] 03/03/04 02:13PM >>>
-----Original Message-----
From: Nick Han [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 03, 2004 5:00 PM
To: CF-Talk
Subject: Re: Call PL/SQL function from ColdFusion 5?
> Matt, if your function returns a string value, you can do something like
this:
> <cfquery ..>
> select myFunction(arg....) from dual
> </cfquery>
Interesting. Unfortunately it has four out parameters that I need to pick
up too. For this particular problem, I wrote a procedure to wrap around the
function. I'm just curious now if there is any way to get at one from CF.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
