Forum Discussion
Thanks for the Help.
var connection = null;
function getConnection(){
if (connection == null) {
connection = ADO.CreateConnection();
connection.ConnectionString = getConnectionString();
connection.Open();
}
return connection;
}
var gnCommand = null, gnReturn, gmParam;
function get_Name(ID_OBJECT) {
//FUNCTION GET_NAME(ID_OBJECT IN VARCHAR2) RETURN VARCHAR2;
if (gnCommand == null) {
gnCommand = ADO.CreateCommand();
gnCommand.ActiveConnection = getConnection();
gnCommand.CommandText = "{?=call GET_NAME(?)}";
gnReturn = gnCommand.CreateParameter("RETURN", adVarChar, adParamReturnValue, 1024, null);
gmParam = gnCommand.CreateParameter("ID_OBJECT", adVarChar, adParamInput, 1024, null);
gnCommand.Parameters.Append(gnReturn);
gnCommand.Parameters.Append(gmParam);
}
gmParam.Value = ID_OBJECT;
gnCommand.Execute();
return gnReturn.Value;
}
Related Content
Recent Discussions
- 4 hours agoSubhraDas
- 17 hours agoJacobjacob44