P
P
power_ranger2021-11-25 11:32:54
SQL
power_ranger, 2021-11-25 11:32:54

The problem is in PL/SQL. I'm new to SQL and I can't get the script to run. How to fix?

Hello everyone, I am new to SQL and my script is not running. What needs to be fixed?
if vErr = 0
then
if( select * from qdg q
where q.iqd in (2,3)
and q.iqdg = 0)
then
CLOSE(r,
c,DOC,D,N,G,P, PC );
else
ACC1.Change(
p_acc => P,
p_cur=> vC,
p_pr => '3',
p_b => 'By order of IS system ID=' || DOC,
p_err => vErr )
619f49b8b83ca986031014.jpeg
Throws this error for if and else

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question