jknj72
asked on
Function issue
Im using SQL Developer and I have a function that cleans non ascii values from strings but when there is an & in the name being cleaned, it prompts me. I know that if I run the function with SET DEFINE OFF it wont prompt me. Problem is I cant include SET DEFINE OFF in my function? How can I include either in my function or in my procedure that is calling my function or whether or not this can be done at all?
ASKER
Is there any way I can get around this using SQL Developer?
I don't use SQL Developer that much, but I would assume that it can run a script, like SQL*Plus can. Include the SET DEFINE OFF in the script before the function call. Then run the script and don't run the function directly.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
First line was the key....I couldnt run it until you said this...Thanks
SET DEFINE OFF isn't a option for Oracle. That prompt isn't coming from the database. It is coming from the tool (specifically SQL Developer in your case, but SQL*Plus does the same thing).
If you ran that same function from a Java application (for example), you wouldn't be prompted.