PL/SQL (remote procedure call)

From: Sonja ©ehoviæ <sonja.sehovic_at_pbz.hr>
Date: Wed, 27 Jun 2001 01:59:48 -0700
Message-ID: <F001.00339908.20010627020150@fatcity.com>

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 test_at_dev.world
        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: sonja.sehovic_at_pbz.hr

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: ListGuru_at_fatcity.com (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). Received on Wed Jun 27 2001 - 03:59:48 CDT