Receive an unexpected symbol error in my PLSQL query [closed]

by

You appear to have an extra quote in your query. The following should work for you:

vSQl := 'select toValueText(a.code, a.descr) from 
        (select currency_code code, des1 descr '||'from sy_curr_code ) a ';

Note the quote before your closing parenthesis has been removed.

More Related Contents:

  1. PL SQL UPDATE STATEMENT
  2. Search All Fields In All Tables For A Specific Value (Oracle)
  3. Is there a combination of “LIKE” and “IN” in SQL?
  4. Is it possible to output a SELECT statement from a PL/SQL block?
  5. REGEX to select nth value from a list, allowing for nulls
  6. SQL to generate a list of numbers from 1 to 100
  7. How to use BOOLEAN type in SELECT statement
  8. SQL recursive query on self referencing table (Oracle)
  9. How can you tell if a value is not numeric in Oracle?
  10. create table with sequence.nextval in oracle [duplicate]
  11. IF EXISTS condition not working with PLSQL
  12. PLS-00428: an INTO clause is expected in this SELECT statement
  13. passing table and column name dynamically using bind variables
  14. WHERE IN condition not accepting String value
  15. Is there any way to flush output from PL/SQL in Oracle?
  16. Sleep function in ORACLE
  17. Solution to “cannot perform a DML operation inside a query”?
  18. Array in IN() clause oracle PLSQL
  19. PLSQL Insert into with subquery and returning clause
  20. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  21. What does the colon sign “:” do in a SQL query?
  22. How to query a CLOB column in Oracle
  23. Oracle (Old?) Joins – A tool/script for conversion?
  24. Advice Using Pivot Table in Oracle
  25. Creating or simulating two dimensional arrays in PL/SQL
  26. How to handle optional parameters in SQL query?
  27. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  28. How to check if a column exists before adding it to an existing table in PL/SQL?
  29. How to call Oracle MD5 hash function?
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment