Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    How to call rest api which accept x-www-form-urlencoded in PL/SQL procedure in Apex

    How to call rest api which accept x-www-form-urlencoded in PL/SQL procedure in Apex I am calling https://api.textlocal.in/docs/sendsms
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Error in pl/sql code

    When i try to run this code: DECLARE STUDENT_ID NUMBER; BEGIN -- Generate the next value for the sequence SELECT LMS_STUDENT_DETAILS_SEQ.nextval; -- Insert data into LMS_STUDENT_DETAILS table INSERT INTO LMS_STUDENT_DETAILS (STUDENT_ID, STUDENT_NAME, GENDER, DATE_OF_
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Mixed version dataguard

    According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed. Could you please just confirm that 11.2 -> 12.2 is really possible? If so, what about 11.2 -> 19.x ? Or 12.2 -> 19.x ? Of cours...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Is it a must to run pupbld.sql as system

    Tom, I create databases then I run the catalog.sql and catproc.sql. Sometimes, I donot run pupbld.sql. Users may get warning message but they could login and work. But, My friend says that if pupbld.sql is not run as system then users will get the error messages and they cannot l...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ORA-01034: ORACLE NOT AVAILABLE

    connect system password : password. i got following errors ORA-01034: ORACLE NOT AVAILABLE ORA-27101: shared memory realm does not exist
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report