guesty_mcguest

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.

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.

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??

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