Can you use your native sql to create Oracle functions and run them? The functions were included in their where statements within their select statement. We are in 8.1.05. Has anyone done this successfully? Thank you.

This message has been edited. Last edited by: FP Mod Chuck,

Kathy

Did you try to use SQL Passthru?

Of course. She gets an error saying it can't find the function that is being used in the SQL passthru. Sorry, I should have said passthru instead of native SQL. Is there a way for the passthru to see the libraries where the functions are?

Kathy

I don't know the answer to that. It is based on a database connection so I kind of doubt it. You can wait to see if anyone else has done it or open a case with techsupport.

Hi Kathy,
If your question is which schema the function is in, then you can run something like the following in the SQL pass-thru:

SELECT OWNER AS "SCHEMA", OBJECT_TYPE, OBJECT_NAME, STATUS
FROM ALL_OBJECTS
WHERE OBJECT_TYPE='FUNCTION'
END

Just add 'AND OBJECT_NAME = 'XXXX' where 'XXXX' is the name of the function you are looking for.

This has been resolved. The user did not have the proper access per the user. Thank you!