Conference orarep::nomahs::rdb_60

        Could you perhaps elaborate on what problems you are seeing? What
        does the procedure do? Can you see your process attach in the
        monitor log? Is the call the only thing being done in the attach?
        If you select data prior to making the call is that successful?
        
        I think we need a bit more info before we can help/
        
        Dave

    Actually, all I want to know is if it can be done and an example of how
    to call it from the Oracle SQLPLUS session.

    >>>  Actually, all I want to know is if it can be done and an example of how
    >>>  to call it from the Oracle SQLPLUS session.
         
    Me two. 
    
    I have a request open with INFODEC.us and Response.uk (TAR 837602.1)
    for this. Happy to see I am not alone...
    
    /Regina 

>    I have a request open with INFODEC.us and Response.uk (TAR 837602.1)
>    for this. Happy to see I am not alone...
    
    Sorry, but I gave your TAR to Richard :-(
    
    I think that what you need to do to make the call is to create a link
    to the Rdb database, and then invoke the procedure as you would an
    Oracle7 remote procedure. From SQL*Plus I think it is something like
    
    EXECUTE procname@link(param);
    
    I haven't tried it though - I've just had a look at the manuals.
     
    Peter

    
    >>>  Sorry, but I gave your TAR to Richard :-(
                
    Wait a minute: you mean I have a question about an original Oracle
    product (as compared to an ex-DEC product), submit it to the what I
    think correct channel with people who should know, and it ends up in 
    our camp anyway just because there is Rdb on the other end? 
    
    At least you seem to have documentation, so I'll leave it with you
    guys...  ;-)
    
    /Regina
     

>                   -< Why does this end up in the Rdb camp? >-
    
    The email mentioned Rdb so it was forwarded to the Rdb Support group
    recipient - me. I saw that it didn't belong in our group, so I spoke to
    someone in the right group - Richard, who has abandoned Rdb for the
    delights of supporting Oracle7 :-) Since he has been rather busy today,
    I thought I would try to help, by looking in the manual.
    
    Besides, I suspect that such calls will be moving to our group when
    native connect is released.
    
    Peter

        
        I would still like to know what happens when you try to invoke the
        procedure. does Rdb generate errors? if so what are they?
        
        .0 said that they could attach to the database and run a select,
        so we know that the attach works, what happens with the procedure?
        
        Dave

>        I would still like to know what happens when you try to invoke the
>        procedure. does Rdb generate errors? if so what are they?
    
    We haven't tried it yet. We were trying to work out how to do it. The
    syntax is different from Rdb (no CALL statement) and the Oracle7 Server
    SQL Reference manual has nothing about invoking a procedure.
    
    Richard is going to try it this morning (I don't know how to invoke
    SQL*Plus).
    
    Will some future version of SET DIALECT ORACLE LEVELn allow procedures
    to be invoked without using CALL?
    
    Peter

    Right, I have tried to run a procedure from an Oracle SQL*Plus
    session.  The database link from Oracle to Rdb works ok as i explained
    in 0.  However, when I do the call to the procedure using the format
    below which myself and Pete have managed to decifer from the manuals I
    getthe error message given:
    
    SQL> begin
      2  p1@rkrdb('10');
      3  end;
      4  /
    p1@rkrdb('10');
    *
    ERROR at line 2:
    ORA-06550: line 2, column 1:
    PLS-00313: 'P1' not declared in this scope
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    
    The procedure P1 is defined within Rdb as:
    
    CREATE MODULE DATA_INSERT
      LANGUAGE SQL
      AUTHORIZATION RKNIGHT
    PROCEDURE P1
         ( :X CHAR(5) );
         BEGIN
           INSERT INTO S (SNUM) VALUES (:X);
         END;
    END MODULE;
    
    Richard
    

    Received:                       Sent: February 2, 1997 11:07pm
    From:     Marcus MacNeill <MMACNEIL.US.ORACLE.COM>
    To:       RROHR.CH
    Subject:  Fwd: Question about TG4Rdb
    Cc:       infodec
    Quote:  In chaos, the experienced business traveller finds opportunity.
    
    Hi Regina,
    
    I'm afraid the answer is no.  Base development introduced the ability
    to call stored procedures from a transparent gateway starting with the
    transparent gateway 4.0 kernel.  Although we have ported 4.0 internally, 
    we are not planning a 4.0-based TG4RDB release until we receive a version 
    of the transparent gateway toolkit that is built on R7.3 (the current
    4.0 kernel is built on 7.2).
    
    For more information about where we stand regarding TG4RDB and TG4RMS,
    please see the current OpenVMS Product Line Update on the Corp
    Repository (under the "Digital" InfoKit).
    
    Regards,
    
    -- Mac