Stored Procedure from PowerBuilder

[siraj777]

Hi,

I am calling a stored procedure from Powerbuilder using n_tr.procedurename(parameters). This procedure will take set of rows and does something.

Surprisingly it works fine in PowerBuilder Debug mode (process all rows called from a loop), but in runtime it blowsup after processing only 1st record.

Blowing up means the procedure is executed only the first 10 lines even though there is no condition (like if) transferring the control elsewhere.

COMMIT;
SQLCA.PROCNAME(parms)
COMMIT;

Thanks for your help in advance.

 

[royjimenez]

hi!I'd like knowing more about your sp, but here goes a tip:


If u need to create a temp table ( for reports ), i could set

sqlca.AUTOCOMMIT = true
sqlca.storeprocedure( ... )
sqlca.AUTOCOMMIT = false


Remember test sqlca.sqldbcode to retrieve the message error.

Luck!

 

[siraj777]

Sorry. It didn't work out.

 

[royjimenez]

Sorry, but with no code i cann't figure out your problem.

 

[siraj777]

COMMIT;
Do
COMMIT;
SQLCA.MoveTimelines( is_cono, is_plant,is_dept,is_oldcctr, li_rtn )
COMMIT;
i = i + 1
LOOP WHILE li_rtn > 0 and i <= 0
COMMIT;

 

[PowerObject]

The first COMMIT inside the loop and the COMMIT after the loop are logically 'not' required.

Have you tried moving the COMMIT statement into your stored procedure? Further, try applying the latest free EBF patches from Sybase.com for your version.

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group