Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Calling Oracle Stored Function calls using JDBC?

4 posts in Appeon (partner product) Last posting was on 2004-03-15 12:33:39.0Z
JDBC Posted on 2004-03-11 21:25:48.0Z
From: "JDBC" <jdbc@pbAppeon.com>
Newsgroups: sybase.public.appeon
Organization: 12.42.131.10
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Calling Oracle Stored Function calls using JDBC?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 64.79.161.46
Message-ID: <4050da13$1@forums-2-dub>
X-Original-Trace: 11 Mar 2004 13:28:51 -0800, 64.79.161.46
Lines: 14
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Mar 2004 13:25:33 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Mar 2004 13:25:48 -0800
X-Trace: forums-1-dub 1079040348 10.22.108.75 (11 Mar 2004 13:25:48 -0800)
X-Original-Trace: 11 Mar 2004 13:25:48 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:158
Article PK: 20607

To prepare our application for Appeon Server, we are changing our Oracle DB
interaction from Native Oracle Driver to using JDBC so we can deploy the app on
Appeon.

Does someone know the SYNTAX on how to call oracle stored function from PB using
JDBC.

Some sample code would be apprecaited..



---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Julie Jiang Posted on 2004-03-12 09:42:29.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <4050da13$1@forums-2-dub>
Subject: Re: Calling Oracle Stored Function calls using JDBC?
Lines: 164
Organization: Appeon Corporation
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0469_01C40859.331BADA0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
X-Original-NNTP-Posting-Host: 61.144.207.53
Message-ID: <40518601@forums-2-dub>
X-Original-Trace: 12 Mar 2004 01:42:25 -0800, 61.144.207.53
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Mar 2004 01:42:26 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Mar 2004 01:42:29 -0800
X-Trace: forums-1-dub 1079084549 10.22.108.75 (12 Mar 2004 01:42:29 -0800)
X-Original-Trace: 12 Mar 2004 01:42:29 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:159
Article PK: 12407

Hi,
 
Please note that "to prepare your application for Appeon Server", it is uncessary to change the function call from using Native Oracle Driver to using JDBC.  The Web application connects to Appeon Server connection cache, and Appeon only requires that the driver specified in the connection cache is JDBC driver.
 
Nevertheless, the following is the syntax for calling Oracle stored function from PowerBuilder using JDBC:
 
 --PB Cursor style call
     declare lcs_test2 cursor for execute up_orp501_002(:ls_id);
     open lcs_test2;
     fetch lcs_test2 into :ls_name;
     close lcs_test2;
 
--PB Procedure style call
     declare lcs_test2 procedure for up_orp501_002(:ls_id);
     execute lcs_test2;
     fetch lcs_test2 into :ls_name;
     close lcs_test2;
 
---Function Declare
     create or replace function up_orp501_002(av_id varchar2)
        return varchar2 is                                  
            lv_name orp_emp.v_name%type;                        
     begin                                               
      select v_name                                       
       from orp_emp                                  
      where v_id = av_id;   
 
Regards,
Julie Jiang
Appeon Corporation
 
"JDBC" <jdbc@pbAppeon.com> wrote in message news:4050da13$1@forums-2-dub...
>
> To prepare our application for Appeon Server, we are changing our Oracle DB
> interaction from Native Oracle Driver to using JDBC so we can deploy the app on
> Appeon.
>
> Does someone know the SYNTAX on how to call oracle stored function from PB using
> JDBC.
>
> Some sample code would be apprecaited..
>
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


JDBC Posted on 2004-03-12 16:47:08.0Z
From: "JDBC" <jdbc@pbAppeon.com>
Newsgroups: sybase.public.appeon
Organization: 12.42.131.10
References: <4050da13$1@forums-2-dub> <40518601@forums-2-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Calling Oracle Stored Function calls using JDBC?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 64.79.161.46
X-Original-NNTP-Posting-Host: 64.79.161.46
Message-ID: <4051e98c$1@forums-1-dub>
Date: 12 Mar 2004 08:47:08 -0800
X-Trace: forums-1-dub 1079110028 64.79.161.46 (12 Mar 2004 08:47:08 -0800)
X-Original-Trace: 12 Mar 2004 08:47:08 -0800, 64.79.161.46
Lines: 67
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:161
Article PK: 20606

The call to Procedure works.

BUT I am looking for a call from PB to Oracle FUNCTION that returns a value
using JDBC. Do you also have an example for that?

Thanks for your prompt reply.




On 12 Mar 2004 01:42:29 -0800,
in sybase.public.appeon

Julie Jiang <julie.jiang@appeon.net> wrote:
>Hi,
>
>Please note that "to prepare your application for Appeon Server", it is

uncessary to change the function call from using Native Oracle Driver to using
JDBC. The Web application connects to Appeon Server connection cache, and
Appeon only requires that the driver specified in the connection cache is JDBC
driver.
>
>Nevertheless, the following is the syntax for calling Oracle stored function
from PowerBuilder using JDBC:
>
> --PB Cursor style call
> declare lcs_test2 cursor for execute up_orp501_002(:ls_id);
> open lcs_test2;
> fetch lcs_test2 into :ls_name;
> close lcs_test2;
>
>--PB Procedure style call
> declare lcs_test2 procedure for up_orp501_002(:ls_id);
> execute lcs_test2;
> fetch lcs_test2 into :ls_name;
> close lcs_test2;
>
>---Function Declare
> create or replace function up_orp501_002(av_id varchar2)
> return varchar2 is
> lv_name orp_emp.v_name%type;
> begin
> select v_name
> from orp_emp
> where v_id = av_id;
>
>Regards,
>Julie Jiang
>Appeon Corporation
>
>"JDBC" <jdbc@pbAppeon.com> wrote in message news:4050da13$1@forums-2-dub...
>>
>> To prepare our application for Appeon Server, we are changing our Oracle DB
>> interaction from Native Oracle Driver to using JDBC so we can deploy the app
on
>> Appeon.
>>
>> Does someone know the SYNTAX on how to call oracle stored function from PB
using
>> JDBC.
>>
>> Some sample code would be apprecaited..
>>
>>
>>
>> ---== Posted via the PFCGuide Web Newsreader ==---
>> http://www.pfcguide.com/_newsgroups/group_list.asp


Julie Jiang Posted on 2004-03-15 12:33:39.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <4050da13$1@forums-2-dub> <40518601@forums-2-dub> <4051e98c$1@forums-1-dub>
Subject: Re: Calling Oracle Stored Function calls using JDBC?
Lines: 95
Organization: Appeon Corporation
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
X-Original-NNTP-Posting-Host: 61.144.207.53
Message-ID: <4055a29e@forums-2-dub>
X-Original-Trace: 15 Mar 2004 04:33:34 -0800, 61.144.207.53
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Mar 2004 04:33:37 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Mar 2004 04:33:39 -0800
X-Trace: forums-1-dub 1079354019 10.22.108.75 (15 Mar 2004 04:33:39 -0800)
X-Original-Trace: 15 Mar 2004 04:33:39 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:163
Article PK: 12409

If you have used RPC call to Oracle FUNCTION in your PowerBuilder
application, Appeon recommends you take one of the following two workarounds
before you convert the application with Appeon:

1) Using server NVO, i.e. placing the RPC call in a standard class (of
Transaction type), and then deploying the class to EAServer. Please get
detailed instructions about the server NVO workaround from the section 4.2,
Distributed desktop applications, in the Appeon Migration Guide.

2) Changing "call to Oracle Function" to "call to Oracle stored procedure".
Place the function in a stored procedure, and have the OUT or IN OUT
parameter of the stored procedure as the return value of the function.

Regards,
Julie Jiang
Appeon Corporation

"JDBC" <jdbc@pbAppeon.com> wrote in message news:4051e98c$1@forums-1-dub...
>
> The call to Procedure works.
>
> BUT I am looking for a call from PB to Oracle FUNCTION that returns a
value
> using JDBC. Do you also have an example for that?
>
> Thanks for your prompt reply.
>
>
>
>
> On 12 Mar 2004 01:42:29 -0800,
> in sybase.public.appeon
> Julie Jiang <julie.jiang@appeon.net> wrote:
> >Hi,
> >
> >Please note that "to prepare your application for Appeon Server", it is
> uncessary to change the function call from using Native Oracle Driver to
using
> JDBC. The Web application connects to Appeon Server connection cache, and
> Appeon only requires that the driver specified in the connection cache is
JDBC
> driver.
> >
> >Nevertheless, the following is the syntax for calling Oracle stored
function
> from PowerBuilder using JDBC:
> >
> > --PB Cursor style call
> > declare lcs_test2 cursor for execute up_orp501_002(:ls_id);
> > open lcs_test2;
> > fetch lcs_test2 into :ls_name;
> > close lcs_test2;
> >
> >--PB Procedure style call
> > declare lcs_test2 procedure for up_orp501_002(:ls_id);
> > execute lcs_test2;
> > fetch lcs_test2 into :ls_name;
> > close lcs_test2;
> >
> >---Function Declare
> > create or replace function up_orp501_002(av_id varchar2)
> > return varchar2 is
> > lv_name orp_emp.v_name%type;
> > begin
> > select v_name
> > from orp_emp
> > where v_id = av_id;
> >
> >Regards,
> >Julie Jiang
> >Appeon Corporation
> >
> >"JDBC" <jdbc@pbAppeon.com> wrote in message
news:4050da13$1@forums-2-dub...
> >>
> >> To prepare our application for Appeon Server, we are changing our
Oracle DB
> >> interaction from Native Oracle Driver to using JDBC so we can deploy
the app
> on
> >> Appeon.
> >>
> >> Does someone know the SYNTAX on how to call oracle stored function from
PB
> using
> >> JDBC.
> >>
> >> Some sample code would be apprecaited..
> >>
> >>
> >>
> >> ---== Posted via the PFCGuide Web Newsreader ==---
> >> http://www.pfcguide.com/_newsgroups/group_list.asp