Discy Latest Questions

swamy kumar
swamy kumar

swamy kumar

View Profile
  • 0
Contributor
Asked:
  • 0

HI, how to download a zip file which is stored in directory with the button click in oracle apex I had written a process to call it but throwing the error as syntaxError: Unexpected token 'P', "PK"... is not valid JSON.. Here is my piece of code written in processing: declare Lob_loc bfile; begin Lob_loc := bfilename('ABC_DIRECTORY','data file.zip'); OWA_UTIL.MIME_HEADER( 'application/zip', FALSE ); htp.p('Content-Disposition: attachment; filename="'||'data file.zip"'); owa_util.http_header_close; wpg_docload.download_file(Lob_loc); apex_application.stop_apex_engine; exception when others then raise_application_error(-20002, SQLCODE||' — '||SQLERRM); apex_application.stop_apex_engine; end;  

oracleoracle apexoracle sql
jocelyn626
jocelyn626

jocelyn626

View Profile
  • 0
Contributor
Asked:
  • 0

Hi, I'm building a page in APEX. In that page I have 2 items, "text field with autocomplete" Both of them are getting the LOV from the same table but different column.  text_field_1 getting the id_1; text_field_2 getting the id_2 So If I input/select a value from text_field_1 I can set a value automatically to text_field_2  or vice versa.  I can do one is to one relationship, like if I enter "bca" in text_field_2, I can set the correct value for text_field_1 which is "2"  But I'm having a problem for the one is to many relationship. If I enter "1" in text_field_1, It will return 2 values which are "abc,cba" I'm trying to figure it out on how I list the abc and cba so that I can still choose what value I want from the two.  Please someone help me with this? 

apexoracleoracle apexquestion
Chandu
Chandu

Chandu

View Profile
  • 0
Contributor
Asked:
  • 0

Hi, I have 80+ reports in my project those all generated through orcle10g report builder.When we place report request through oracle forms report builder will generates the reports.But going forward report build will not be available.we have to convert all reports into pl/sql code logic. Through forms we have to call pl/sql pkg and we have to generate the report data and we have to place in unix sever.How we can achieve this requirement?

oraclepl/sql
Old Questions
Advertisement