sql - Why does this stored procedure not work? -


i'm not quite sure why stored not working. getting message saying "pl/sql statement not ended".

create or replace procedure approveuser (     seuser in users_stock_exchanges.username%type,     semanager in stock_exchanges.stock_exchange_manager%type )          begin       update users_stock_exchanges set verify_status=1       users_stock_exchanges use         inner join            stock_exchanges se         on            use.stock_exchange_id = se.stock_exchange_id       use.username = seuser       ,  se.stock_exchange_manager = semanager;      end approveuser; 

there no joins in update statement, see this question , oracle sql documentation.

in case write this

update users_stock_exchanges use  set    verify_status = 1   exists (select 1                   stock_exchanges se                  use.stock_exchange_id = se.stock_exchange_id                        , use.username = seuser                       , se.stock_exchange_manager = semanager); 

Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -