open id 

christopher_salas

all messages by user

7/2/2021
Topic:
Parameterized Oracle Packages

christopher_salas
christopher_salas
Is there a specific syntax to call oracle package procs with parameters? Ive tried below but nothing seems to work:

KMPROD.PACKAGE_WEB_VALIDATION_PROCS.VALIDATE_ACCTUNIT(:Entity, :Account, :TOC);
exec KMPROD.PACKAGE_WEB_VALIDATION_PROCS.VALIDATE_ACCTUNIT(:Entity, :Account, :TOC);
KMPROD.PACKAGE_WEB_VALIDATION_PROCS.VALIDATE_ACCTUNIT :Entity, :Account, :TOC

Any help is appreciated.
9/16/2021
Topic:
SQL Byte[] to Object

christopher_salas
christopher_salas
I have a query that is returning a Byte[] as one of the field types. I need to convert this back to the object that is stored there. Is there a function for this?
10/6/2021
Topic:
Compress Images

christopher_salas
christopher_salas
We have a flow that takes in an image and saves it as part of the Data Structure. As this has grown the size of the DB table has grown, thus slowing all of the Fetch steps down. Is there an internal feature or step i can use to compress these images?
10/8/2021
Topic:
Export Dependencies For an Object

christopher_salas
christopher_salas
I have an integration stored proc that changed, and i need to change all of the dependencies for this object. Is there an easy way to export the dependencies of the proc?
5/12/2022
Topic:
Word Checkbox

christopher_salas
christopher_salas
Is there a way to tell if a checkbox is checked in a word document? I am using the "Get Text From Document Bookmark" step and all is says is FORMCHECKBOX. Any help is appreciated.




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software