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!

pl/sql insert ---- username/sysdate

911012Jan 15 2012 — edited Feb 6 2012

I'm having troubles figure out why doesn't this work

sample database

name(varchar2)
user_name(varchar2)
timestamp(date)

i made a process after submit for a button call "add record"

insert into table_name
(name,user_name,timestamp)
values(:P1_name, nvl(v('APP_USER'),USER), to_date(sysdate,'YYYY/MM/DD'))

but for some reason i get a null value error for nvl(v('app_user),user) when i click the submit button.

for the sysdate im wonder if i got the right syntax?

any help i would really apperciate it.

Edited by: PandaOracle on Jan 15, 2012 6:53 PM

This post has been answered by Jozef Demovic SVK on Jan 16 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2012

Added on Jan 15 2012

#apex, #apex-discussions, #database, #date, #error, #plsql, #sql

7 comments

2,547 views