Hi,
I'm in an environment where there's a apex server and a database server. All built database objects are link to the apex server via database links. I was using the v and nv function via a stored procedure like so on the apex server:
CREATE OR REPLACE
PROCEDURE PR_INS_TMP_STUDENTS(
v_tmp_stu_id_in IN NUMBER
)
IS
BEGIN
INSERT INTO TMP_STUDENTS (
stu_id,
stu_name_last,
stu_name_first,
stu_name_middle,
stu_name_suffix,
stu_name_prefer_last,
stu_name_prefer_first,
sch_id
)
VALUES (
v_tmp_stu_id_out,
v('p50100_stu_name_last'),
v('p50100_stu_name_first'),
v('p50100_stu_name_middle'),
v('p50100_stu_name_suffix'),
v('p50100_stu_name_prefer_last'),
v('p50100_stu_name_prefer_first'),
nv('p50100_sch_id')
);
END;
It works fine on the apex server but when I moved the procedure to the database server it didn't compile. It complains about PL/SQL: ORA-00904: "V": invalid identifier.
How can I get the v and nv function to work on the database side?