How to execute a Package/Function in PB ?

[vulcanjena]

I'm using ORACLE9 with PB9.
I have a package defined with many functions for a massive calculations. How can I execute that package in PB scipt ?

 

[PowerObject]

Declare it as an local external function for your transaction object and use it as a regular function. Use the right mouse button popup menu and choose:

Paste Special -> SQL -> Remote Stored Procedure(s)...


---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group

 

[vulcanjena]

The script for the packages/function is like shown below.

//---------------
BEGIN
IF cmo_utilities.cmo_calculate_massive THEN
dbms_output.put_line(' Recalculate Process finished successfully ');
ELSE
dbms_output.put_line(' Recalculate Process has errors. Please check logs in CMO_LOGS table ');
END IF;
COMMIT;
END;
//---------------

cmo_calculate_massive is the function within
the package cmo_utilities.

I'll appereciate if you can tell me how can I declare it as
a function and execute that script ?

Thanks in advance.
JENA

 

[PowerObject]

You may declare local external functions in your transaction object as under:

FUNCTION boolean CalculateMassive() RPCFUNC ALIAS FOR &quot;<user>.CMO_UTILITIES.CMO_CALCULATE_MASSIVE&quot;
SUBROUTINE PutLine ( string as_Line ) RPCFUNC ALIAS FOR &quot;SYS.DBMS_OUTPUT.PUT_LINE&quot;

Or you may declare them in your scripts:

DECLARE CalculateMassive PROCEDURE for <user>.CMO_UTILITIES.CMO_CALCULATE_MASSIVE
DECLARE PutLine PROCEDURE for SYS.DBMS_OUTPUT.PUT_LINE

and call the functions just like any other function:

IF CalculateMassive() THEN
PutLine( ... )
END IF

Subroutines are for functions that don't return any value.

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group

 

[vulcanjena]

Thanks for the reply ..get back asap.