TOracleObject.Create raises access violation

[rimmingtond]

When I try to create an oracle object I get an access violation.

The code I am writing is:-

var
MyObject: TOracleObject;
begin
MyObject := nil;
MyObject := TOracleObject.Create(MySession, 'MyObjectName', '');

 

[Marco Kalter]

Can you let me know the address and module of the access violation?

 

[harshank]

Hi Marco,

I am trying to create a TOracleObjest with the help of following linkhttps://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=47875

but getting access violation at the time on create myObject.

MY delphi code:
var
i: Integer;
StringTable, INTTable : TOracleObject;
begin
MainDataModule.OracleQuery1.DeclareVariable('FP_ID', otObject);
MainDataModule.OracleQuery1.DeclareVariable('FP_STR', otObject);
StringTable := TOracleObject.Create(MainDataModule.OracleQuery1.Session, 'number_table_t', '');
INTTable := TOracleObject.Create(MainDataModule.OracleQuery1.Session, 'varchar_240_table_t', '');

Getting access violation at the time create StringTable in delphi.

---------------------------
Test_Collection
---------------------------
Access violation at address 00647E92 in module 'Test_Collection.exe'. Read of address 00000288.
---------------------------
OK
---------------------------

 

[harshank]

Updated code:

used uppercase and schema

StringTable := TOracleObject.Create(MainDataModule.OracleQuery1.Session,
'SSC.VARCHAR_240_TABLE_T', '');
INTTable := TOracleObject.Create(MainDataModule.OracleQuery1.Session,
'SSC.NUMBER_TABLE_T', '');

Still same issue.