Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v and nv function

600830Oct 19 2009 — edited Oct 19 2009
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?
This post has been answered by 438381 on Oct 19 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2009
Added on Oct 19 2009
2 comments
2,472 views