[sqr-users] Can execute Oracle stored procedure only x number oftimes?

[Clark Murray <gyozaking@yahoo.com>]

Our environment is:
SQR server 8.2 on Win 2003 SP1
Oracle 9.2.0.5


    The program generates lists of customers.  It loops through a list of 
customer IDs and for each one it calls a stored procedure to get the customer's 
name, address, etc.  It works just fine until it has done 253 records, then it 
reports an error in executing the procedure.  I don't know whether or not this 
is significant, but the last character of the procedure name is truncated in 
the error message:

Error on line 91:
   (SQR 3913) Could not EXECUTE stored procedure or function.

SQL: EXEC  Transcription_Utilities.Get_Transcription_Recor

Error on line 91:
   (SQR 3913) Could not EXECUTE stored procedure or function.

SQR: Program Aborting.


Is there an issue with the record it's trying to process?  No -- it's handled 
just fine if I change the selection criteria so that that customer is within 
the first 253.  If I rerun it, it processes the remainders just fine (so long 
as there are less that 254, I assume).

The code I believe to be relevant follows.


!------------------------------------------------------------ Get_Record
begin-procedure Get_Record
execute do=write_transcription_record
!  on-error=Oracle_Error
    @#proc_return_status = Transcription_Utilities.Get_Transcription_Record
    @p_customer_id       = #customer_id
  , @p_output_record     = $transcription_record OUTPUT
end-procedure Get_Record

!--------------------------------------------  Write_Transcription_Record
begin-procedure Write_Transcription_Record
!display $transcription_record
write 1 from $transcription_record
add 1 to #record_count
end-procedure Write_Transcription_Record




Any insight into this issue will be greatly appreciated.

Clark Murray


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users