Warning |
---|
Looking for the documentation on the newest versions of SIL Engine and the Simple Issue Language for Jira 8 for Server/Data Center? Click here ! |
Info | ||
---|---|---|
| ||
This routine is available starting with SIL Engine™ 3.0.6. |
Syntax
sqlCallStoredProcedureWithOutParams(datasourceName, procedureName, [params])
...
In the next table you can see the mapping between SQL Types and SIL SIL™ Types:
SQL Type | SIL Type |
---|---|
User-defined collection | ARRAY |
CHAR | CHAR |
NUMBER | DECIMAL |
NUMBER | FLOAT |
NUMBER | INTEGER |
LONG | LONG |
REF CURSOR | REF CURSOR |
DATE | TIMESTAMP |
VARCHAR2 | VARCHAR2 |
...