Calling stored procedure with Pro*C
From: John Howard <jphoward_at_amoco.com>
Date: 1995/08/11
Message-ID: <40fu1g$lpc_at_tabloid.amoco.com>#1/1
(1) PCC-S-02000, Statement ignored
Date: 1995/08/11
Message-ID: <40fu1g$lpc_at_tabloid.amoco.com>#1/1
I'm trying to call a stored porc from a Pro*C program.
From what I can tell form the manuals this should work :-
EXEC SQL EXECUTE
TEST.INS(:in_text, :numeric, :in_date, :err_code);
BEGIN
TEST.INS(:in_text, :numeric, :in_date, :err_code);
END;
END-EXEC;
But I get an error from the pre-compiler :-
.................................1
(1) PCC-S-02201, identifier 'TEST.INS' must be declared
TEST.INS(:in_text, :numeric, :in_date, :err_code);
............................1
(1) PCC-S-02000, Statement ignored
Any clues ?
Sorry if this is an RTFM error but it's late Friday afternoon and my brain is dead.
Thanks in advance,
John
-- John Howard Data Management Snr Programmer/Analyst Technical ServicesReceived on Fri Aug 11 1995 - 00:00:00 CEST
(Socon 822 7084) Amoco (UK) Exploration Co.