Rick
|
| Posted: 09/12/2002, 1:39 PM |
|
Hi,
I'm trying to invoke a stored procedure from a CCS grid. I used the procedure dialog (very nice). I'm passing one input parameter. When I kick off the page it comes back with:
Source: Grid Payer_Address
Error: 3 (Microsoft OLE DB Provider for SQL Server)
sp_getOrgUp;1
what is the? ;1
....thanks,
---------------
My SP follows: (not the most elegant but is works fine on it's own)
CREATE procedure sp_getOrgUp (@payer_org_id int) as
DECLARE @payer_org_parent_id int, @message varchar(200), @prevId0 int, @prevId1 int, @prevId2 int, @prevId3 int, @prevId4 int
set @prevId0 = @payer_org_id
DECLARE p1_cursor CURSOR FOR
SELECT payer_org_id, payer_org_parent_id
FROM payer_sub_org where payer_org_id = @prevId0
OPEN p1_cursor FETCH NEXT FROM p1_cursor INTO @payer_org_id, @payer_org_parent_id
set @prevId1 = @payer_org_parent_id
print @prevId1
DECLARE p2_cursor CURSOR FOR
SELECT payer_org_id, payer_org_parent_id
FROM payer_sub_org where payer_org_id = @prevId1
OPEN p2_cursor FETCH NEXT FROM p2_cursor INTO @payer_org_id, @payer_org_parent_id
set @prevId2 = @payer_org_parent_id
print @prevId2
DECLARE p3_cursor CURSOR FOR
SELECT payer_org_id, payer_org_parent_id
FROM payer_sub_org where payer_org_id = @prevId2
OPEN p3_cursor FETCH NEXT FROM p3_cursor INTO @payer_org_id, @payer_org_parent_id
set @prevId3 = @payer_org_parent_id
print @prevId3
DECLARE p4_cursor CURSOR FOR
SELECT payer_org_id, payer_org_parent_id
FROM payer_sub_org where payer_org_id = @prevId3
OPEN p4_cursor FETCH NEXT FROM p4_cursor INTO @payer_org_id, @payer_org_parent_id
set @prevId4 = @payer_org_parent_id
print @prevId4
CLOSE p1_cursor
CLOSE p2_cursor
CLOSE p3_cursor
CLOSE p4_cursor
DEALLOCATE p1_cursor
DEALLOCATE p2_cursor
DEALLOCATE p3_cursor
DEALLOCATE p4_cursor
select * from payer_address where payer_org_id = @prevId0
union
select * from payer_address where payer_org_id = @prevId1
union
select * from payer_address where payer_org_id = @prevId2
union
select * from payer_address where payer_org_id = @prevId3
union
select * from payer_address where payer_org_id = @prevId4
GO
|
|
|
 |
rick
|
| Posted: 09/12/2002, 2:05 PM |
|
I saw the problem once I read my own post.
I had left some print statements in the SP for debuging, they were causing the burb...
Thanks anyway...
|
|
|
|
Rao
|
| Posted: 09/12/2002, 7:11 PM |
|
Rick,
Are you talking of Stored Procedure as input to Grid / Record / Grids&Record Builders? If so, can you please explain, where you have specified the Stored Procedure as Input / Data Source?
Rao
chtvrao@valona.com
|
|
|
|
|
