Call Oracle PL/SQL function from Nice Label

Label printing integration (NiceWatch middleware and ActiveX programming interface)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
tss
Newcomer
Posts: 1
Joined: Tue Apr 12, 2022 1:44 pm

Call Oracle PL/SQL function from Nice Label

Post by tss » Thu Apr 14, 2022 1:28 pm

Hi,

i need to call an Oracle function from Nice Labe Designer 2019.
I tried this but it doesn't work.

SELECT "CONTRACT",
"PART_NO",
"PART_PRODUCT_CODE",
"DESCRIPTION",
"Inventory_Product_Code_API.Get_Description(part_product_code)"
FROM "IFSAPP"."INVENTORY_PART"

Is it even possible to call a function from Nice Label Designer?

Thanks for a hint.

Thomas

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 295
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Call Oracle PL/SQL function from Nice Label

Post by Mytch » Thu Apr 28, 2022 6:32 pm

Thomas,

You can connect to related Oracle database and make new Query object:
https://help.nicelabel.com/hc/en-001/ar ... eries-1-61

I recommend option #1 - you should be able to define your custom query with the function and return the selected result.

Regards,
Mytch

Post Reply