I am unable to insert the result set of query into corresponding SQL Table type variable where as
same functionality can be accomplished by PL/SQL table type variable. Can't we access the same by using SQL type variable?

I have a procedure with input parameter as SQL table type collection object. But we are not sure about the ordering the collection object.
I need to perform some operations on ordered collection only ( ordered key should be one of attribute of Object type .In above example Key should be Deptno ).
First I need to apply the ordering logic on in/put parameter then need to apply actual procedure logic.

Instead of defining one more pl/sql object , just i want to use same data type as input parameter

1/ This is what I recommend. Bad performances, hard to read, hard to maintain, hard to write...
2/ Quote:

In the below example we are storing some static hard values into SQL type variable

In your example you do not store in the database, this is what I meant by "store".

Quote:

I have a procedure with input parameter as SQL table type collection object. But we are not sure about the ordering the collection object.
I need to perform some operations on ordered collection only ( ordered key should be one of attribute of Object type .In above example Key should be Deptno ).
First I need to apply the ordering logic on in/put parameter then need to apply actual procedure logic.

It is not clear but it seems you understand what I mean with "hard to write"...

Quote:

Instead of defining one more pl/sql object , just i want to use same data type as input parameter

There I really don't understand what you have and what you want.
An example may be useful.