Ask Anantha

Download your free copy of E-Book  Cloud Architecture for Dummies & Cloud Considerations & Connectivity   brought to you by Oracle. Click here to download your copy . This is an Oracle Special edition.  Grab your copy before the offer is taken out.

I was creating a custom function (for demo purposes) and was stumbled with this error. ORA-44004: invalid qualified SQL name I was referring to my code in APEX 4.0 which was calling the procedure as return f_validate; I was trying to do the same in APEX 4.2.1 also. But I was continuously bugged by this or some other error.

ORA-31011: XML parsing failed while calling srw.run_report from database Below is a sample report calling block I copied from Oracle Forums. There was a mistake in the block which was causing the error ORA-31011: XML parsing failed. The solution is simple. the GATEWAY parameter had a 'question mark' at the end of the link. If you see the output generated by srw.start_debugging, the URL framing would be listed there: http://192.168.50.53:7778/reports/rwservlet?&SERVER=rep_dev&report=rep_name&userid=user/pass@sid&destype=file&desformat=pdf&destination=/u01/&distribute=yes If you notice closely there is a & added before SERVER parameter. This is due to the presence of the ? SRW.ADD_PARAMETER of GATEWAY. If you remove the ? from the last of link the report will be invoked. DECLARE v_paramlist srw_paramlist; v_jobident srw.job_ident; v_status srw.status_record;  BEGIN srw.start_debugging; v_paramlist := srw_paramlist(srw_parameter('...

Oracle's Web Toolkit (HTP/HTF) supports creating webpages with full control. I have been using them for my official project and we have built a framework associated with a style sheet we have created. Among other things it supports uploading files by user. Using the HTML INPUT type="file" we can position the file selection dialog. The form needs to be open with multipart/form-data. For the first time if you are using this functionality you may have to configure the table name where Oracle populates the file in a BLOB column. The configuration is part of DAD , placed in Database server within / dbfolder /Apache/modplsql/conf/dads.conf file. " dbfolder " is where you have installed the database. In the Location tag specify a table for the attribute      PlsqlDocumentTablename MYDOCUMENTS A sample document table can consist of the following: CREATE TABLE [table_name] (   NAME VARCHAR2(256) UNIQUE NOT NULL,   MIME_TYPE VARCHAR2(128), ...

I am deeply privileged to have contacted by  Packt Publishing  for reviewing their new book intended to teach recipes for securing Oracle 11g database against a typical hacker. The book is authored by Adrian Neagu. The authors profile is available in the publishers website . A sample chapter is available for free reading in this link  or for download  as PDF file. You may buy either ebook (all formats such as Kindle, PDF, epub are available) or print version which includes ebook if you buy online from this website . The book is meant for mid level DBAs who has basic understanding of security concepts. Its not at all an entry level DBAs book.

This is a mini-tip on changing characters entered in a text/input field to all Capital letters. A little use of Javascript is required. Navigate to the page where the changes is required. Click on the field/Item for which all capital characters is required. Scroll till you reach Element section and in "HTML Form Element Attributes" mention the following (including quotes): onKeyUp="this.value=this.value.toUpperCase();" Now Click on Apply Changes button and run the page. For the field this attribute is applied, whenever a key is typed the case is changed. But if you dont want this type of animation and just want all characters to be in upper case no matter what, add the following to the text field: style="text-transform: uppercase;" onKeyUp="this.value=this.value.toUpperCase();" To learn more about text-transform click here . The style attribute is a CSS property and applies an all UPPER CASE property to the text field. Even though the...

Apex Version 4.0.2 I am using a template where my contents are appearing in one side (left) and navigation in another side (right) of the webpage. I created a "Vertical Sidebar List" template wherein all my navigation items will be embedded inside an un-ordered List. I created this very much easily. First created a List (Application Builder > My Application > Shared Components > Lists (Below Navigation)). The List template as I mentioned earlier is "Vertial Sidebar List". I entered a few pages in the navigation items and created the list. Later on I manually added a List Region to all my pages. I chose the Display Point of "Page Template Region Position 2" for my page contents, and for Menu I chose "Page Template Region Position 3". Thus I was able to list both regions side by side. But the problem I landed on was that when I click on a page the list was not displaying current attribute (or a highlighting). Even after lot of go...