• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

error procedure

SQL> EXEC sysman.setEMUserContext(”,5);    
BEGIN sysman.setEMUserContext(”,5); END;

ERROR at line 1:
ORA-06550: line 1, column 31:
PLS-00103: Encountered the symbol "?" when expecting one of the following:
( ) - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table continue avg count current exists max min prior sql
stddev sum variance execute multiset the both leading
trailing forall merge year month day hour minute second
timezone_hour timezone_minute timezone_region timezone_abbr
time timestamp interval date
<a string literal with character set specification>

1 Solution
Helena Markováprogrammer-analystCommented:
There is mistake there:
EXEC sysman.setEMUserContext(,5);

Try changing ” with ''
EXEC sysman.setEMUserContext('',5);
Gerwin Jansen, EE MVETopic Advisor Commented:
The procedure setEMUserContext is expecting 2 parameters, have a look at the procedure what the parameters are. If you specify 2 like you are doing and the first one is an empty string then 2 single quotes specify an empty string as Henka is mentioning ('').
tomvvAuthor Commented:

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now