Data.SqlExpr.TSQLConnection.GetProcedureParams

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

procedure GetProcedureParams(ProcedureName : string; List: TProcParamList); overload;
procedure GetProcedureParams(ProcedureName, PackageName: string; List: TProcParamList); overload;
procedure GetProcedureParams(ProcedureName, PackageName, SchemaName: string; List: TProcParamList); overload;

C++

void __fastcall GetProcedureParams(System::UnicodeString ProcedureName, System::Generics::Collections::TList__1<SPParamDesc*>* List)/* overload */;
void __fastcall GetProcedureParams(System::UnicodeString ProcedureName, System::UnicodeString PackageName, System::Generics::Collections::TList__1<SPParamDesc*>* List)/* overload */;
void __fastcall GetProcedureParams(System::UnicodeString ProcedureName, System::UnicodeString PackageName, System::UnicodeString SchemaName, System::Generics::Collections::TList__1<SPParamDesc*>* List)/* overload */;

Properties

Type Visibility Source Unit Parent
procedure
function
public
Data.SqlExpr.pas
Data.SqlExpr.hpp
Data.SqlExpr TSQLConnection

Description

Populates a list with parameter descriptors for the parameters in a stored procedure.

Call GetProcedureParams to retrieve information about the parameters of a specified stored procedure.

ProcedureName is the name of the stored procedure for whose parameters you want descriptions.

PackageName is the name of the Oracle package to which the stored procedure belongs. This parameter should only be used if TSQLConnection connects to an Oracle server.

List is a TList object that receives the parameter descriptions. It should be an empty list on entry. For each parameter, GetProcedureParams adds a reference to an SPParamDesc class (Delphi) or structure (C++). Each SPParamDesc entity describes a parameter of a specified stored procedure, including its name, index, parameter type, field type, and so on. You are responsible for freeing the individual SPPParamDesc entities that GetProcedureParams dynamically allocates. (You can use FreeProcParams to free all the entries and the list object as well).

Note: You can convert the list of SPParamDesc entities to the more familiar TParams object by calling the global LoadParamListItems procedure.

See Also