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.

Can't run Oracle procedures

6 posts in Appeon (partner product) Last posting was on 2008-05-28 05:27:10.0Z
Chris Posted on 2008-05-13 21:29:42.0Z
From: Chris <cmetalic@gmail.com>
Newsgroups: sybase.public.appeon
Subject: Can't run Oracle procedures
Date: Tue, 13 May 2008 14:29:42 -0700 (PDT)
Organization: http://groups.google.com
Lines: 15
Message-ID: <0135745b-7329-4e3c-8471-57d985285c8d@m3g2000hsc.googlegroups.com>
NNTP-Posting-Host: 192.85.37.95
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1210714182 8917 127.0.0.1 (13 May 2008 21:29:42 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 13 May 2008 21:29:42 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: m3g2000hsc.googlegroups.com; posting-host=192.85.37.95; posting-account=9m3qFAoAAACMZc-bJgOV727WMHBNHILK
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!newscon02.news.prodigy.net!prodigy.net!news.glorb.com!postnews.google.com!m3g2000hsc.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2105
Article PK: 13285

Hi guys, I'm having trouble converting a call to an oracle procedure
from c/s mode to web. Below is my PB code. This works when I run in
c/s, but I get an oracle error (wrong number or types of arguments in
call to 'LOCK_USER'). I have only one in argument - a varchar2 for
the user ID. And I can call from SQL (not to mention c/s), so I have
permissions to run the procedure.

Do I not have it declared properly for Appeon?

PB:
string user_id
user_id = 'test'
declare lock_user procedure for snpcommon.lock_user(:user_id) using
sqlca;
execute lock_user;


steven.yang Posted on 2008-05-14 09:06:15.0Z
Sender: 36ed.482aa58b.1804289383@sybase.com
From: steven.yang
Newsgroups: sybase.public.appeon
Subject: Re: Can't run Oracle procedures
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <482aab87.38a3.1681692777@sybase.com>
References: <0135745b-7329-4e3c-8471-57d985285c8d@m3g2000hsc.googlegroups.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 May 2008 02:06:15 -0700
X-Trace: forums-1-dub 1210755975 10.22.241.41 (14 May 2008 02:06:15 -0700)
X-Original-Trace: 14 May 2008 02:06:15 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2106
Article PK: 21523

Hi Chris,
Appeon support this feaure.

Please provide me with the following information below so
that I can further the study:
a) AppeonServer.log;
b) AppeonError.log;
c) Appeon version and EBF.
d) How do you define procedure in database.

Regards


Chris Posted on 2008-05-14 12:28:10.0Z
From: Chris <cmetalic@gmail.com>
Newsgroups: sybase.public.appeon
Subject: Re: Can't run Oracle procedures
Date: Wed, 14 May 2008 05:28:10 -0700 (PDT)
Organization: http://groups.google.com
Lines: 42
Message-ID: <c6a40eee-e2e1-42ea-bc24-6799545766bf@s50g2000hsb.googlegroups.com>
References: <0135745b-7329-4e3c-8471-57d985285c8d@m3g2000hsc.googlegroups.com> <482aab87.38a3.1681692777@sybase.com>
NNTP-Posting-Host: 68.50.24.182
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1210768090 584 127.0.0.1 (14 May 2008 12:28:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 May 2008 12:28:10 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: s50g2000hsb.googlegroups.com; posting-host=68.50.24.182; posting-account=9m3qFAoAAACMZc-bJgOV727WMHBNHILK
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!newscon02.news.prodigy.net!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!s50g2000hsb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2107
Article PK: 13283


On May 14, 5:06 am, steven.yang wrote:
> Hi Chris,
> Appeon support this feaure.
>
> Please provide me with the following information below so
> that I can further the study:
> a) AppeonServer.log;
> b) AppeonError.log;
> c) Appeon version and EBF.
> d) How do you define procedure in database.
>
> Regards

a) Last entries in AppeonServer.log:
1210438154046:1 [08-05-10 12:49:14.046] [com.appeon.Server (run)] It's
not a cluster version server.
1210624813078:1 [08-05-12 16:40:13.078] [com.appeon.Server (run)] It's
not a cluster version server.
1210690203257:1 [08-05-13 10:50:03.257] [com.appeon.Server (run)] It's
not a cluster version server.
1210727027015:1 [08-05-13 21:03:47.015] [com.appeon.Server (run)] It's
not a cluster version server.
b) The AppeonError.log is completely empty.
c) The Appeon version is 5.0.0092.00; I have not loaded any EBFs for
Appeon; I am using PB 10.5.2 Build 7016
d) The Oracle procedure is defined as:
create or replace procedure snpcommon.lock_user (
my_user_id varchar2
) AUTHID CURRENT_USER is
begin
update snpcommon.schema_user set lock_ind = 1 where user_id =
my_user_id;
commit;
end lock_user;


Upon further investigation, I did not define the original call using
SQLCA as the transaction object, but another transaction object which
is defined as an instance variable and created and connected to the DB
in the same script (above the call). When I use SQLCA instead, the
call works, but when I use the instance transaction object, it does
not. Does the transaction object have to be global?


steven.yang Posted on 2008-05-22 01:48:37.0Z
Sender: 4f23.4834cb18.1804289383@sybase.com
From: steven.yang
Newsgroups: sybase.public.appeon
Subject: Re: Can't run Oracle procedures
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4834d0f5.4f83.1681692777@sybase.com>
References: <c6a40eee-e2e1-42ea-bc24-6799545766bf@s50g2000hsb.googlegroups.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 May 2008 18:48:37 -0700
X-Trace: forums-1-dub 1211420917 10.22.241.41 (21 May 2008 18:48:37 -0700)
X-Original-Trace: 21 May 2008 18:48:37 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2114
Article PK: 21521

Hi Chris,
Did you specify the connection cache for the instance
variable transaction objects in AEM Console > Application
Properties > Transaction Objects?

Regards


Chris Posted on 2008-05-23 15:41:27.0Z
From: Chris <cmetalic@gmail.com>
Newsgroups: sybase.public.appeon
Subject: Re: Can't run Oracle procedures
Date: Fri, 23 May 2008 08:41:27 -0700 (PDT)
Organization: http://groups.google.com
Lines: 14
Message-ID: <17c04c4f-ca2e-48c9-a4d0-544fa3f401a3@a70g2000hsh.googlegroups.com>
References: <c6a40eee-e2e1-42ea-bc24-6799545766bf@s50g2000hsb.googlegroups.com> <4834d0f5.4f83.1681692777@sybase.com>
NNTP-Posting-Host: 68.48.240.247
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1211557287 8303 127.0.0.1 (23 May 2008 15:41:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 23 May 2008 15:41:27 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a70g2000hsh.googlegroups.com; posting-host=68.48.240.247; posting-account=9m3qFAoAAACMZc-bJgOV727WMHBNHILK
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeeds.sol.net!10.218.45.202.MISMATCH!newspump.sol.net!198.186.194.249.MISMATCH!transit3.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!a70g2000hsh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2123
Article PK: 13290

Yes, I had the connection cache defined, but not linked (I don't have
SQLCA linked either). They are both linked dynamically in the code.
For example, I have the following defined:

transaction DBGrantor
DBgrantor = Create transaction
DBgrantor.Database = sqlca.database // I know this isn't used for the
connection - I am using for other purpose.
dbgrantor.dbms = 'JDB-O10'
DBgrantor.dbparm = "CacheName='snpmis_grantor'"
CONNECT USING DBgrantor;

I get no errors on the connection.


Steven Yang Posted on 2008-05-28 05:27:10.0Z
Sender: 43e3.483ba395.1804289383@sybase.com
From: Steven Yang
Newsgroups: sybase.public.appeon
Subject: Re: Can't run Oracle procedures
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <483ced2e.710f.1681692777@sybase.com>
References: <17c04c4f-ca2e-48c9-a4d0-544fa3f401a3@a70g2000hsh.googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 May 2008 22:27:10 -0700
X-Trace: forums-1-dub 1211952430 10.22.241.41 (27 May 2008 22:27:10 -0700)
X-Original-Trace: 27 May 2008 22:27:10 -0700, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2131
Article PK: 13295

Hi Chris,
Appeon supports dynamic transaction object to connection
cache mapping. But the connection cache name for the
CacheName parameter is case sensitive.
You said: "The Appe_onError.log is completely empty.", this
is because you didn’t set log mode to debug. So please go
to AEM and set the Log mode to debug and then reproduce the
problem to obtain so to get some hints:
a) AppeonServer.log;
b) AppeonError.log;

BTW, Appeon 5.0.0092.00 is an old version. I suggest you
obtain the newest Appeon Edition and do your test basing on
that.

regards
Steven

> Yes, I had the connection cache defined, but not linked (I
> don't have SQLCA linked either). They are both linked
> dynamically in the code. For example, I have the following
> defined:
>
> transaction DBGrantor
> DBgrantor = Create transaction
> DBgrantor.Database = sqlca.database // I know this
isn't
> used for the connection - I am using for other purpose.
> dbgrantor.dbms = 'JDB-O10'
> DBgrantor.dbparm = "CacheName='snpmis_grantor'"
> CONNECT USING DBgrantor;
>
> I get no errors on the connection.
>