HI all,
I am using Oracle Forms 10g. i have a remote database and i have created a database link to that db. Now i need to update some data in that database from my system using forms. For that i wrote a statement like ,
execute immediate 'SELECT GLH_CODE_SEQ.NEXTVAL@WB INTO '||GLHCODE||' FROM DUAL'; (glh_code_seq is a sequence in remote db)
but its showing error like error 591: this feature is not supported in client side programs.
then i changed the statement to ,
forms_ddl('SELECT GLH_CODE_SEQ.NEXTVAL@WB INTO '||GLHCODE||' FROM DUAL');
Now that error is not popping but the variable is not receiving any value.
The same statement(forms_ddl) is working fine on sql*plus.
Someone pls help me on whether i'm doing anything wrong or suggest whether anything to be done on this.
Thank You,
Sandeep