This discussion is archived
6 Replies Latest reply: Sep 11, 2013 12:56 AM by 1013248 RSS

assign value into variable

1013248 Newbie
Currently Being Moderated

Hello,

 

I use the APEX 4.2 and an Oracle DB 11g.

I made an APEX-Page where I have a text field that should show the value of an SELECT-Statment. The text fields name is TEXTFIELD_3.

 

SELECT anr INTO :TEXTFIELD_3 FROM article LIMIT 1;

 

When I execute the statement directly on the DB I get a value, but while executing it in my APEX-Application I'll get the ORA-01403 Error.

 

Do you have a suggestion why I get that Error?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points