Stored procedures - executing

Help!

I am having trouble executing a stored procedure from a host program.

My stored procedure can be executed from SQLPLUS and works fine. The procedure inserts a tuple into a customer table:

eg.
Table Customer
ID (varchar(10)) | Name (varchar(20)) |

------------------------+-----------------------|
1			| Fred			|
2			| Jerald		|

procedure insert_customer( new_name varchar ) as begin

	insert into customer( id, name )
	vaules (idSeq.NEXTVAL, new_name);

where idSeq is a previously defined sequence

proc program:
.
.
.

exec sql begin declare section;

        varchar new_name[20];
exec sql end declare section;

exec sql include sqlca;
.
.
.

strcpy( new_name.arr, "Test Customer");
new_name.len = strlen( new_name.arr );
.
.
.

exec sql execute

	begin
		insert_customer( :new_name );
	end;

there are no errors identified.
the program attaches to the database fine.

it seams that the stored procedure (insert_customer) doesn't execute.

can anybody help?

thanx in advance

Mike Dasler

is40509_at_otago.ac.nz Received on Mon Aug 08 1994 - 02:40:09 CEST