Re: PL/SQL (remote procedure call)

From: <G.Plivna_at_itsystems.lv>
Date: Wed, 27 Jun 2001 02:26:13 -0700
Message-ID: <F001.003399A0.20010627023629@fatcity.com>

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_at_repsislink

PL/SQL procedure successfully completed.

SQL> exec qaqa_at_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 
<ORACLE-L_at_fatcity.com>       
                    c_at_pbz.hr>            cc:                                           
                            
                    Sent by:             Subject:     PL/SQL (remote procedure call)   
                            
                    root_at_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 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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: G.Plivna_at_itsystems.lv

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