topic Re: PROCEDURE CREATION ERROR in Application Development and Automation Discussions

PROCEDURE CREATION ERROR

former_member698032 — Sat, 26 Sep 2020 02:23:20 GMT

Good Morning

I am trying to create a procedure, however there is a error in VAR2 for incorrect syntax.

Checked the procedure but couldnt identify the same.

Could you please support.

Please refer to attachment.

Yogananda — Sat, 26 Sep 2020 03:30:28 GMT

Hi bande_ramesh91

your referring Var1 in Var2 block which Var1 is not present... Kindly create as a table and call it in var2

Former Member — Sat, 26 Sep 2020 04:18:31 GMT

Hi bande_ramesh91,

Your procedure has a couple of syntax issues. Please fix that.

1. The VAR1 assignment should end with a semicolon(;) and that's why you are getting syntax error - (line no 11)

2. After fixing the above you would get an error at OUT_TABLE - (line no19).
The query should look like below:

SELECT SUM(SALES_AMOUNT) AS SALES_AMOUNT, SUM(SALES_AMOUNT-(SALES_AMOUNT*:DISCOUNT/100)) AS NET_AMOUNT....

Thanks