Execute Immediate : Encountered the symbol

oracle function select plsqldeveloper execute-immediate
J2H656 picture J2H656 · May 21, 2013 · Viewed 8k times · Source

i am currently getting this error ORA-06550 PLS-00103 Encountered the symbol "VERSION"...

Can any one help me rectify this problem? Much appreciated!

declare
sql_stmnt VARCHAR(200);
lsparameter varchar(50);
lsparameterdata varchar(20);

begin
 sql_stmnt := 'SELECT parameter, parameter_data into lsparameter, lsparameterdata FROM MyTable WHERE parameter = 'version'';
 EXECUTE IMMEDIATE sql_stmnt;
end;

I know i am already setting the parameter to "version" in the where clause. I want to retrieve the parameter and parameter_data from MyTable to check the version and then to continue with the rest of my function.

Thanks in advance.

Answer

haki picture haki · May 21, 2013

you need to escape the character ' like this 

 sql_stmnt := 'SELECT parameter, parameter_data into lsparameter, lsparameterdata FROM MyTable WHERE parameter = ''version''';

and your are missing an into after the execute immediate.

Related questions

PLS-00201 - identifier must be declared

I executed a PL/SQL script that created the following table TABLE_NAME VARCHAR2(30) := 'B2BOWNER.SSC_Page_Map'; I made an insert function for this table using arguments CREATE OR REPLACE FUNCTION F_SSC_Page_Map_Insert( p_page_…

Read More
Split function in oracle to comma separated values with automatic sequence

Need Split function which will take two parameters, string to split and delimiter to split the string and return a table with columns Id and Data.And how to call Split function which will return a table with columns Id …

Read More
executing a function in sql plus

I created a function in oracle that inserts records in specific tables and return an output according to what occurs within the function. e.g (ins_rec return number) How do I call this function and see its output in …

Read More