View Single Post
  #6 (permalink)  
Old 03-18-10, 15:14
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,150
>I have a function as below, which is working fine.
>is the string and obviously it does not execute

Please make up your/our mind.

>so is there any better approach
I don't have your tables.
I don't have your data.
I don't have your functions or procedures.
I don't understand your exact requirements.

using sqlplus along with CUT & PASTE post results showing whole session where code functions as desired utilizing a single hard coded value as a starting point.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.

Last edited by anacedent; 03-18-10 at 15:28.
Reply With Quote