Jump to content


guesty_mcguest

Member Since 05 Sep 2003
Offline Last Active Jul 20 2004 06:30 AM
-----

Posts I've Made

In Topic: Returning variables to PRO4 from PLSQL?

23 April 2004 - 03:18 AM

:-"
You may want to  try this code to get count , sum or total.

SQL
  BEGIN
    SELECT COUNT(*) INTO :#VAR
    WHERE CLAUSE ;
  END ;
ENDSQL


I've been unable to get this to work - thought it was maybe because I'm on 4.6.

I was putting the code in a global logic - seemed an ideal place for it. Turns out it doesn't work there.

Exactly the same code in a funtion works fine. :)

In Topic: Returning variables to PRO4 from PLSQL?

15 April 2004 - 09:34 AM

Well whaddya know!

I'm sure I tried this years ago and I couldn't get it to work with a function as a column - must have just been doing something wrong. :)

So, the easiest, and most easy to maintain method for solving kwong's original problem is just to have the pl/sql routine convert the number to a string and return that and then pro-iv can convert it to a number.

In Topic: Returning variables to PRO4 from PLSQL?

14 April 2004 - 10:19 AM

The "steamroller" method works...

In your pl/sql multiply the result by 100.

In your pro-iv divide the result returned by pl/sql by 100.
:)


Now, anybody got any clues on returning strings from pl/sql??

In Topic: ProIV 5.5 on AIX5 32bit?

12 September 2003 - 03:03 AM

Don't believe everthing you read!
Oracle 9i will apparently run on a 32bit aix server as Oracle have told us.
Just wondering if anyone had done it - obviously not.
(upgrading to 9i is cost neutral for us, buying a new server is not!)

Re pro-IV, on the official site I can only see a download for r308 for aix3.4, not aix5- is this the one to download?
Does this version actually work with 9i? (the pro-iv supported platform grid suggests not?)

Cheers all