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!

get value from TextField Apex 19

ManuelGonzalezOct 4 2019 — edited Nov 8 2019

How do I concatenate a value taken from a text Field in an sql statement.  Example:

select * from v$instance@:P10_NEW_1;

ORA-20999: Failed to parse SQL query! <p>ORA-06550: line 1, column 26: ORA-01729: database link name expected</p>

:P10_NEW_1 is a  Text Field  that changes according to what the user enters

Comments
Post Details
Added on Oct 4 2019
4 comments
3,414 views