SP2 Issue running simple Oracle package.

General discussion forum about all databases other than SqlBase.
lairton
Brazil
Posts: 170
Joined: 15 Mar 2017, 19:32
Location: Brazil

SP2 Issue running simple Oracle package.

Post by lairton » 22 Sep 2010, 12:38

The following instruction run correctly in all CTD1.5.1 and TD5.2 SP1 EMP 5259.
But NOT with TD5.2 SP2.

I isolate the problem.

!!CB!! 70
Call SqlConnect ( hSql )
Set sFilial = "001"
Set nQtdPedidos = 1
Set asPedidos [0] = "00004470"
Set sPLSQLCommand = "PCK_PIR_PEDIDO_VENDA.MudaStatusPedidos( sFilial, nQtdPedidos, asPedidos, dtCancel, nCodErro)"
Call SqlPLSQLCommand( hSql, sPLSQLCommand)

error no: 1618
msg: Invalid parameter type for procedure/external function

The problem is that in TD5.2 SP1 EMP 5259 anothers packages call stops with a sql error that does not occurs with TD5.2 SP2.
So I have some of code that going to error in TD5.2 SP1 EMP 5259 and another part of our application that stops in an error with TD5.2 SP2.

Unify already knows this error ?

How can I help you to reproduce this error ?

the way it is now our client does not approve our system.
I need to have two computers with different deployment files to our application would place orders on a computer and finish the sale in another computer.

this situation is very dangerous to us.

KimF
Finland
Posts: 71
Joined: 04 May 2017, 03:49
Location: Finland

Re: SP2 Issue running simple Oracle package.

Post by KimF » 22 Sep 2010, 13:43

Hello - we just managed solve the reason to this error - you can't have a DATE parameter after a ARRAY parameter.
This problem occurred after installing SP2

huiskala

Re: SP2 Issue running simple Oracle package.

Post by huiskala » 23 Sep 2010, 06:46

lairton wrote:The following instruction run correctly in all CTD1.5.1 and TD5.2 SP1 EMP 5259.
But NOT with TD5.2 SP2.
As Kim already answered, we have also encountered this problem and seen that it is the datatype and order of PL/SQL input parameters which causes the SQL error.

I guess in your PL/SQL call

Code: Select all

PCK_PIR_PEDIDO_VENDA.MudaStatusPedidos( sFilial, nQtdPedidos, asPedidos, dtCancel, nCodErro)
the parameter "nQtdPedidos" is an array of numbers (maybe a dynamic one?)
and "dtCancel" is a date. Did I guess right?

As a workaround, try to change the order of parameters. E.g. move the number array to the first parameter, or the last. For us this has helped.
lairton wrote:this situation is very dangerous to us.
For us too, so we are waiting a quick fix from Unify. They are aware of this issue and currently investigating it. Hopefully more information is received within the next few days.

lairton
Brazil
Posts: 170
Joined: 15 Mar 2017, 19:32
Location: Brazil

Re: SP2 Issue running simple Oracle package.

Post by lairton » 23 Sep 2010, 13:38

Hi, Thank you for help!

That's right! The problem is solved by making the change positions of the parameters.

Is very important that we give a quick answer from Unify (maybe an EMP) about it, because we can not change these parameters in all the packages that we use parameters with date and using arrays. We have about 400 cases of this type of call in our application!

lairton
Brazil
Posts: 170
Joined: 15 Mar 2017, 19:32
Location: Brazil

Re: SP2 Issue running simple Oracle package.

Post by lairton » 25 Sep 2010, 05:02

gotta get back to this post because the situation is complicated.
move parameters to another position is a very delicate contour.

what to do when a case like this?
PCK_Abc (arrayNumber1, arrayNumber2, arrayNumber3, arraydate1, arraydate2, arrayDate3)
move to where the arrays?
do not tell me the solution is to do this:
PCK_Abc (arrayNumber1, stringDummy1, arrayNumber2, stringDummy2, arrayNumber3, stringDummy3, arraydate1, stringDummy4, arraydate2, stringDummy5, arrayDate3)

This situation clearly sets a bug in version 5.2.2 sqlora32.dll
I know for sure because if I change just this dll, putting the dll 5.2.1 the application works.

Bob

Re: SP2 Issue running simple Oracle package.

Post by Bob » 18 Oct 2010, 13:37

We are having the same problems as described by the TS. Could someone at Unify respond to this problem and report when a fix will be available? The discussed workaround is no option. This is fine for figuring out what the problem is, but it is no solution for a serious production system. The original package call that worked flawless in TD3.1 should work in TD5.2 without having to rewrite the entire application.

Jeff Luther

Re: SP2 Issue running simple Oracle package.

Post by Jeff Luther » 19 Oct 2010, 00:18

Could someone at Unify respond to this problem and report when a fix will be available?
Well, it's not quite that simple. If you put together a small and complete test case -- app, Oracle script, etc. -- I can take a look at it when I get time to get to the forum. And if I can verify if, I'll enter it in as a TD defect.

As for when a 'fix will be available', better click here: https://support.guptatechnologies.com/supportforum/viewtopic.php?f=40&t=3398
to understand what you need to do to request an urgent fix.
without having to rewrite the entire application
Well, whatever the problem is, let's all assume you won't have to do that :)

huiskala

Re: SP2 Issue running simple Oracle package.

Post by huiskala » 19 Oct 2010, 19:50

Jeff Luther wrote:
Could someone at Unify respond to this problem and report when a fix will be available?
Well, it's not quite that simple. If you put together a small and complete test case -- app, Oracle script, etc. -- I can take a look at it when I get time to get to the forum. And if I can verify if, I'll enter it in as a TD defect.
There should be no need for anyone else to build a test case any more. We have already done it.

Problem 00012424 with subject "PL/SQL calls give SQL error 1618" has been logged into your system already on 22nd September. There is detailed information and a test case. Both Jeff and Jean-Marc have replied into this case. The status is still "Researching Solution". The last comment by Jean-Marc says that Mike shall take a look on this... So no TD defect number has been assigned yet.

So far we have been able to live with the workaround, in fact this affected only three of our PL/SQL procedures (altogether hundreds of them). But I definitely agree with all of you, this should really be fixed ASAP.

markkuvento

Re: SP2 Issue running simple Oracle package.

Post by markkuvento » 22 Nov 2010, 14:25

FYI: This problem exists also in TD6.0 Build 23285.
Urgent fix needed!
BR, Markku

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests