Телеграмм чат группы orclapex страница 384

Size: a a a

Oracle APEX

2021 March 21

Abhishek

No query as of now. This is a new region which we are going to create. Where can i use the query for Static content region type? I know we can use plsql code in Dynamic content. But it cannot be refresh able.

Why not to use sql based region ? In Static content you cannot use sql.

источник

19:51пожаловаться #1

Abhishek in Oracle APEX

Темик

Why not to use sql based region ? In Static content you cannot use sql.

I tried doing by classic report and changing the template to 'content block' with no result.

источник

20:03пожаловаться #2

Abhishek in Oracle APEX

Темик

Why not to use sql based region ? In Static content you cannot use sql.

Classic report ->
SELECT image FROM images WHERE seqno = :P10_USER_ID;
Template : Content block
Column 1 : Display Image
Set BLOB attributes to same images table as mentioned above.

источник

20:05пожаловаться #3

Темик in Oracle APEX

Abhishek

Classic report ->
SELECT image FROM images WHERE seqno = :P10_USER_ID;
Template : Content block
Column 1 : Display Image
Set BLOB attributes to same images table as mentioned above.

Should work, not sure about template. Not next to my pc at the moment. We using images a lot in our app, no issues at all. And what is the value of :p10_uset_id ? Should be the value of your clicked event, primary key of what ever it is ..

источник

20:14пожаловаться #4

Abhishek in Oracle APEX

Темик

Yes.It is. It has the primary key value of the images table.

источник

20:16пожаловаться #5

Abhishek in Oracle APEX

Темик

Which will be changed on subsequent clicks based on user selection.

источник

20:16пожаловаться #6

Темик in Oracle APEX

Abhishek

Which will be changed on subsequent clicks based on user selection.

Yes, than add a DA to refresh image region, and you are good.

источник

20:40пожаловаться #7

Abhishek in Oracle APEX

Темик

Yes, than add a DA to refresh image region, and you are good.

источник

21:01пожаловаться #8

Abhishek in Oracle APEX

Abhishek

If it is a normal Classic report SQL region, then it is working fine. If I change the template to any other to display the image. It returns this ERROR.

источник

21:02пожаловаться #9

Темик in Oracle APEX

Abhishek

If it is a normal Classic report SQL region, then it is working fine. If I change the template to any other to display the image. It returns this ERROR.

Yeah, that is why I said I'm not sure about your template. Not next to my pc at the moment, so can't look it.

источник

21:06пожаловаться #10

Abhishek in Oracle APEX

Темик

Yeah, that is why I said I'm not sure about your template. Not next to my pc at the moment, so can't look it.

Ok. Thank you.

источник

21:39пожаловаться #11

Michael G in Oracle APEX

okay..

источник