Declare my_cursor procedure for gen_id (: ls_arg) using the sqlca.
Long ll_number
Ll_number=0
The execute my_cursor;
If the sqlca. Sqlcode & lt;> 0 then
.
The else
The fetch lsp_ncounter into: ll_number;
End the if
.
Return (ll_number)

All related operations are in our system using this method take the return value, and are correct.
In the recent few days when I was in a test on the server actually made a mistake, data is removed to take out a:
For example, the database is 1234, and by the fetch lsp_ncounter into: ll_number; After
Ll_number was 123, I dizzy, who met the problem?
I've had a lot of testing on the machine is right

CodePudding user response:

Add: I am using PB11

CodePudding user response:

Do you have any close my_cursor;

CodePudding user response:

Have some, this function has been used for several years, only recently has this kind of situation, the problem of the machine is the server, system is Windows 2003.
If I don't call the SP to pick up the item data is also normal,
Such as: select the column into: ll_number
From the table
Where the key='... '
Ll_number=1234

CodePudding user response:

Other units will not just this one? Would this one before? Really strange, if other normal test results, it should be something is wrong with this one

CodePudding user response:

Yes, this server will appear this kind of circumstance.

CodePudding user response:

Please note long field, in oracle is long field can be variable characters long, can save 2000 characters, not letter you try, defined in oracle long integer, the number with, for example, the test number (18, 0), and so on defined fields, it is not recommended to define with long

CodePudding user response:

I don't know, to help

CodePudding user response:

After the need to focus on, now but first, let me help you