My page is the same as yours. When I right click on columns, I'm not prompted with the "create virtual column" button. Any idea on another way to create one?
Try left clicking on the COLUMNS keyword first. Then right click. You will see at the 2:21 mark in my video I right clicked first and it did not work. Then left clicked so COLUMNS turned green. and on right click it should appear for you to create a virtual column.
I am not sure this can be done out of the box with APEX. This can be done though in Oracle Analytics Cloud though, then potentially embedded in APEX. docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/generate-pdf-output.html
@Chip Baber First, I want to thank you for your response, andI have one more question which I need your advice, if you please I am working on generating TlVQR code, which generate huge value (base64 ), and i need to insert this value (nearly 40000 character), but an error occur, This error about buffer Could you please... tell me what to do to insert and select this value to use in Bi puplisher. Thanks in advance
This is well within the max size of a CLOB. I may need a bit more information to assist, like what form is the base64 inside when you are attempting to ingest. What is the error you are receiving. If it is in say a .txt file you could ingest as a BLOB through a REST API.... If you have a sample you can share send to my email glad to take a look. chipbaber@yahoo.com
In this example, we leverage the basic ctx_doc.filter and set plaintext => true in the parameter. If we set that to false it will convert to HTML. Which will give you a closer output to what you are looking for with line breaks. docs.oracle.com/en/database/oracle/oracle-database/21/ccref/CTX_DOC-package.html#GUID-66B252A2-4C02-4E11-80DF-71BECD3BAFD6
My page is the same as yours. When I right click on columns, I'm not prompted with the "create virtual column" button. Any idea on another way to create one?
Try left clicking on the COLUMNS keyword first. Then right click. You will see at the 2:21 mark in my video I right clicked first and it did not work. Then left clicked so COLUMNS turned green. and on right click it should appear for you to create a virtual column.
Hello, could you help me . I work in orcale apex and I want to generate pdf/a-3 format report Pdf with embedded xml.thanks you
I am not sure this can be done out of the box with APEX. This can be done though in Oracle Analytics Cloud though, then potentially embedded in APEX. docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/generate-pdf-output.html
@Chip Baber
First, I want to thank you for your response,
andI have one more question which I need your advice, if you please
I am working on generating TlVQR code, which generate huge value (base64 ), and i need to insert this value (nearly 40000 character), but an error occur,
This error about buffer
Could you please... tell me what to do to insert and select this value to use in Bi puplisher. Thanks in advance
This is well within the max size of a CLOB. I may need a bit more information to assist, like what form is the base64 inside when you are attempting to ingest. What is the error you are receiving. If it is in say a .txt file you could ingest as a BLOB through a REST API.... If you have a sample you can share send to my email glad to take a look. chipbaber@yahoo.com
thank you
the text apper without new line , why ?
In this example, we leverage the basic ctx_doc.filter and set plaintext => true in the parameter. If we set that to false it will convert to HTML. Which will give you a closer output to what you are looking for with line breaks. docs.oracle.com/en/database/oracle/oracle-database/21/ccref/CTX_DOC-package.html#GUID-66B252A2-4C02-4E11-80DF-71BECD3BAFD6
thank you