Ask next bosses writing storage which is wrong? Write in this way?

Topic is
- call a stored procedure to realize top-up integral to users, and enhance the level of user -
- define top-up integral stored procedure -
- call a stored procedure to realize the integral to users of prepaid phone -
- integral input from the keyboard to top-up -

CodePudding user response:

Select the wrong

The select field into variables from bbsuser;

Dbms_output (variable);

CodePudding user response:

Return a result set, want to use sys_refcursor cursor,

CodePudding user response:

The SQL that was wrong