Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

fill Textfield from Table

818365Feb 11 2011 — edited Feb 11 2011
Hi

A simple task drives me crazy today...

I want to fill a Textfield with a default value.
I wrote this code as a process:
begin
:P9_Textfield := (SELECT my_def_value FROM my_table WHERE my_description = 'take_this_one');
end;
Which causes following Error: 
1 error has occurred

    * ORA-06550: line 3, column 42: PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( - + case mod new not null others <an identifier>...
my_table looks like this:


ID---my_description-------my_def_value
_________________________________
1----"take_this_one"------"def_val1"-----
2--- "not_this"--------------"def_val2"-----


I can't find the reason. What's wrong with this?

Thank you!

pAT
This post has been answered by jariola on Feb 11 2011
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 11 2011
Added on Feb 11 2011
#apex-discussions, #from, #table
3 comments
70 views