I am calling a PL/SQL procedure like this:
execute util.verify(src_schema => '&username',
stab => '&tab_name');
and I get these errors:
SQL> execute util.verify(src_schema => '&username',
BEGIN util.verify(src_schema => 'u1',; END;
*
ERROR at line 1:
ORA-06550: line 1, column 57:
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>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
SQL> stab => '&tab_name',
SP2-0734: unknown command beginning "stab ..." - rest of line ignored.
Looks like I cannot just break the call in between at a ,
. How can I write this call in multiple lines?
PL/SQL supports two comment styles: single-line and multi-line. A double hyphen ( - - ) anywhere on a line (except within a character literal) turns the rest of the line into a comment. Multi-line comments begin with a slash-asterisk ( /* ) and end with an asterisk-slash ( */ ).
PL/SQL supports two comment styles: single-line and multi-line. Single-line comments begin with a double hyphen ( - - ) anywhere on a line and extend to the end of the line. Multi-line comments begin with a slash-asterisk ( /* ), end with an asterisk-slash ( */ ), and can span multiple lines.
The EXIT statement breaks out of a loop. The EXIT statement has two forms: the unconditional EXIT and the conditional EXIT WHEN . With either form, you can name the loop to be exited.
You should use EXIT WHEN statement to exit from the Loop.
In SQLPlus, you put a dash at the end of lines that continues on the next line.
execute util.verify(src_schema => '&username', -
stab => '&tab_name');
Update: Added link to documentation
EXECUTE, SQL*Plus® User's Guide and Reference
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With