CODEWITHSUNDEEP
plsql
Aleksander Lipka
Aleksander Lipka

Reputation: 528

PLSQL Substitue argument of a function with SELECT statement

I would like to display the contents of a BLOB using the functions provided by Anton Scheffer using this query in sql developer:
[1.] select * from table( as_read_xlsx.read( v_blob ) ); --"v_blob" is a variable containing blob with xlsx
but I have BLOB in some other table. To get BLOB i have to use this:
[2.]select bb from at_table_temp where id_c=4

So, the question is how to put [2.] as an argument to [1.]:
select * from table( as_read_xlsx.read([2.]) );

I already tried the following but it didn't work:
select * from table( as_read_xlsx.read( $"[2.]" ) );
select * from table( as_read_xlsx.read( @"[2.]" ) );
select * from table( as_read_xlsx.read( $([2.]) ) );

Looking forward to your answers!

Upvotes: 0

Views: 95

Answers (1)

William Robertson
William Robertson

Reputation: 16001

Try this:

select * from at_table_temp t cross join table(as_read_xlsx.read(t.bb));

Upvotes: 2

Related Questions