Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Supported DBMS features when calling stored procedures – PB Docs 70 – PowerBuilder Library

Supported DBMS features when calling stored procedures – PB Docs 70

Supported DBMS features when calling stored procedures

When you define and use a custom Transaction object to call
remote stored procedures in your application, the features supported
depend on the DBMS to which your application connects.

The following sections describe the supported features for
some of the DBMSs that you can access in PowerBuilder. Read the
section for your DBMS to determine what you can and cannot do when
using the RPC technique in a PowerBuilder application.

note.gif Result sets You cannot
use the remote procedure call
technique to access result sets returned by stored procedures. If
the stored procedure returns one or more result sets, PowerBuilder
ignores the values and returns the output parameters and return
value.

If your stored procedure returns a result set, you can use
the embedded SQL DECLARE Procedure statement to call it.
For information about the DECLARE Procedure
statement, see the chapter on SQL statements in the PowerScript
Reference

.

INFORMIX

If your application connects to an INFORMIX database, you
can use simple nonarray data types. You cannot
use
binary large objects (blobs).

ODBC

If your application connects to an ODBC data source, you can
use the following ODBC features if the backend driver supports them.
(For information, see the documentation for your ODBC driver.)

  • IN, OUT, and IN OUT parameters,
    as follows:

    Parameter What happens
    IN An IN variable is passed by value and
    indicates a value being passed to the procedure
    OUT An OUT variable is passed by reference
    and indicates that the procedure can modify the PowerScript variable
    that was passed. Use the PowerScript REF keyword for this parameter type
    IN OUT An IN OUT variable is passed by reference
    and indicates that the procedure can reference the passed value
    and can modify the PowerScript variable. Use the PowerScript REF
    keyword for this parameter type
  • Blobs as parameters
    You can use blobs that are up to 32,512 bytes long.
  • Integer return codes

ORACLE

If your application connects to an ORACLE database, you can
use the following ORACLE PL/SQL features:

  • IN, OUT, and IN OUT parameters,
    as follows:

    Parameter What happens
    IN An IN variable is passed by value and
    indicates a value being passed to the procedure
    OUT An OUT variable is passed by reference
    and indicates that the procedure can modify the PowerScript variable
    that was passed. Use the PowerScript REF keyword for this parameter type
    IN OUT An IN OUT variable is passed by reference
    and indicates that the procedure can reference the passed value
    and can modify the PowerScript variable. Use the PowerScript REF
    keyword for this parameter type
  • Blobs as parameters
    You can use blobs that are up to 32,512 bytes long.
  • PL/SQL tables as parameters
    You can use PowerScript arrays.
  • Function return codes

Microsoft SQL Server or Sybase Adaptive Server
Enterprise

If your application connects to a Microsoft SQL Server or
Sybase Adaptive Server Enterprise database, you can use the following
Transact-SQL features:

  • IN,
    OUT, and IN OUT parameters, as follows:

    Parameter What happens
    IN An IN variable is passed by value and
    indicates a value being passed to the procedure
    OUT An OUT variable is passed by reference
    and indicates that the procedure can modify the PowerScript variable
    that was passed. Use the PowerScript REF keyword for this parameter type
    IN OUT An IN OUT variable is passed by reference
    and indicates that the procedure can reference the passed value
    and can modify the PowerScript variable. Use the PowerScript REF
    keyword for this parameter type
  • Blobs as parameters
    You can use blobs that are up to 32,512 bytes long.
  • Integer return codes

Adaptive Server Anywhere

If your application connects to an Adaptive Server Anywhere database, you can
use the following Adaptive Server Anywhere features:

  • IN, OUT, and IN OUT parameters,
    as follows:

    Parameter What happens
    IN An IN variable is passed by value and
    indicates a value being passed to the procedure
    OUT An OUT variable is passed by reference
    and indicates that the procedure can modify the PowerScript variable
    that was passed. Use the PowerScript REF keyword for this parameter type
    IN OUT An IN OUT variable is passed by reference
    and indicates that the procedure can reference the passed value
    and can modify the PowerScript variable. Use the PowerScript REF
    keyword for this parameter type
  • Blobs as parameters
    You can use blobs that are up to 32,512 bytes long.

Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x