Using ASA 10 on a windows windows server 2003. I have a stored procedure defined with 'No Result Set' defined. Table a has a trigger that inserts into table B. Table B has a trigger that at the end we have added a call to the new stored procedure. I am getting an error message that says 'Result set not permitted in 'sp_insert_rpt_q_generic' (the new procedure). Not sure what is causing this. Tried debugging but get error message before hitting first line of sp.

example of proc call:

call dba.sp_insert_rpt_q_generic(
@ls_reference,0,null,null,new_name.incident_id,null,current user,null,null)

example of proc dec:

create PROCEDURE "DBA"."sp_insert_rpt_q_generic"(
@invrefnum varchar(10),@rpt_id integer,@a_pts char(200),@dw_report char(75),@a_inc 
char(20),@statusid integer,@a_who char(15),@objid integer,@SS_snd integer)
NO RESULT SET
begin

I do select information into variables in the proc, but none are returned only inserted into a table (if I ever get that far).

We did try recreating this as a function but same issue.

Any input or ideas would be appreciated.

asked 30 Jun '11, 11:49

trexco's gravatar image

trexco
336111423
accept rate: 0%

edited 30 Jun '11, 12:11

Siger%20Matt's gravatar image

Siger Matt
3.1k486493

Is the last statement before the end statement of the procedure some sort of select or return ?

Does the insert into the temporary table cause any triggers to fire that might return something?

(30 Jun '11, 12:24) Siger Matt

"if I ever get that far" - MESSAGE statements inside the STP (in combination with dbsrv10 -o Log.txt) are fine to find out how far you are going - as is the stored procedure debugger....

(30 Jun '11, 12:49) Volker Barth
2

Well I was using the debugger, that was what was frustrating me. After reading the replies realized that the debugger was set to debug a specific user id. Reset debugger to all users and was able to find the issue (a malformed sql statement). Once corrected all went well.

Thanks again for the input

(30 Jun '11, 15:06) trexco
Replies hidden
1

That's just nasty: "set to debug a specific user id"... I could see myself struggling for HOURS before realizing that :)

(01 Jul '11, 14:29) Breck Carter
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×102
×59

question asked: 30 Jun '11, 11:49

question was seen: 820 times

last updated: 01 Jul '11, 14:29