You should call it using parameters at the very end
For example my remote procedure is:
create or replace procedure qaqa (in_bzz IN varchar2 default 'bzzz') is
begin
insert into qaqa1 values (in_bzz);
commit;
end;
/
On current server execute such statements:
SQL> exec qaqa@repsislink
PL/SQL procedure successfully completed.
SQL> exec qaqa@repsislink('asd')
PL/SQL procedure successfully completed.
and the result on the remote server is:
SQL> select * from qaqa1;
COL1
----------
bzzz
asd
Gints Plivna
Sonja �ehovi�
<sonja.sehovi To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
[EMAIL PROTECTED]> cc:
Sent by: Subject: PL/SQL (remote procedure call)
root@fatcity.
com
01.06.27
13:01
Please
respond to
ORACLE-L
List hi!
I created procedure on one instance and want to call it from another
through
database link.
It works just fine when I executed it without passing parameter.
execute procedure [EMAIL PROTECTED]
PL/SQL procedure successfully completed.
When I do
execute procedure test()@dev.world
I get message:
ERROR at line 1:
ORA-06550: line 1, column 14:
PLS-00103: Encountered the symbol "@" when expecting one of the
following:
:= . ( % ;
ORA-06550: line 1, column 26:
PLS-00103: Encountered the symbol "END"
Do you have any suggestions?
TIA,
Sonja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
