Text Import into GLobal temporary Table - Then cannot view results

[deailes]

Hiya

I am trying to figure if i can get this working. I can do it in Toad but the users (including me) prefer PL SQL dev.

I create global temp table with 'on commit preserve rows'.
I upload data to this table using text import. (this is successful).
I then open a SQL window within the same session to then query the data i have just uploaded to the temp table but i am unable to see it.

I have made sure the temp table is in the schema that belongs to the user.

I have tried setting the auto commit option to a number larger than the data i am importing.

I am wondering why i cannot query/see the data or if i am missing an important step or setting somewhere.

I can do the same thing in TOAD but when running the SQL window in toad i execute as script rather than execute/compile statement.

Otherwise feel i am doing everything right. Does anyone have any pointers as to what i might be doing wrong.

It just seems to be an issue when using the text importer. I can open a sql window. Manually insert some rows and then query the datas within the same sql window. But as its a lot of data i need to import then i need the text import functionality.

Is what i am trying to do possible in PL SQL Dev?

Cheers

John

 

[patch]

Are you sure you are using single or dual session mode?
See Preferences - Connection - Session mode

 

[deailes]

Are you sure you are using single or dual session mode?
See Preferences - Connection - Session mode

Splendid. Thanks Muchly. This was exactly the issue. Now working fine in single session mode.