Include function in declare section with @
686258Apr 9 2009 — edited Apr 14 2009I want to "include" a function that's not stored on the database in the declare section of a pl/sql program. This function code resides in an .sql file in the same directory as the calling program. It's a shared function so I don't want to have to include the code in each program.
Below is how I did it and it works but didn't know if this was the only way.
DECLARE
v_return NUMBER :=0;
@f_function_name
BEGIN
v_return := f_function_name(parameters);
..
..
END;
Thanks