thanks Vinish, created function, first tried this and it shows data successfully.

select id, item_name, blob_to_clob(item_image) item_image from items where rownum<=3;

when tried to create another temporary table with this sql statement it throws error:

create table item_blob_test as
select id, item_name, blob_to_clob(item_image) item_image from items where rownum<=3;

ORA-01652: unable to extend temp segment by 128 in tablespace

how to resolve this?

regards

today oracle aske me to change password, now it is:

Ora123cle&

thanks Vinish for prompt response

i added the line as below:

'f?p=&APP_ID.:'||1||':&APP_SESSION.::::P1_CATVAL:'||id as link

replaced "PAGE_NO" with 1 as it was throwing error that PAGE_NO is invalid identifier.

and now after above change (my page no. is 1 Home) it is throwing same error as menitoned in my opening post.

in DA i will refresh my Items region.

please help where i am making mistake(s).

regards