Executing an SQL Script in Oracle Application Express

Salutations,

I have been attempting to execute an SQL Script through Application Express (APEX), the browser-based interface for Oracle DBMS.

However, when I click on the Run button, nothing happens. Suspecting a potential Javascript error, I decided to inspect it using Firebug, which revealed an issue in the javascript code:

this.endLine.isPreceding is not a function
http://localhost:8080/i/editor/codearea.xbl.xml
Line 2864

This was the message displayed by Firebug.

Any insights or suggestions on how to resolve this?

Thank you in advance.

-aw

UPDATE: snippet of the problematic js section

CodeRange.prototype.setStartBeforeEnd = function()
{
  if (this.endLine.isPreceding(this.startLine) ||
    (this.endLine == this.startLine && this.endCol < this.startCol))
  {
    var l = this.endLine;
    this.endLine = this.startLine;
    this.startLine = l;

    var c = this.endCol;
    this.endCol = this.startCol;
    this.startCol = c;
  }
  return this;
};

Answer №1

"I don't believe the SQL is causing this issue."

Try using a different file to help isolate the problem.

It's likely that there is an encoding issue with the file. Have you tried editing it in Application Express?

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Encountering an error when attempting to reach a JSON endpoint using Javascript and X-Auth-Token

I'm attempting to retrieve data from a JSON endpoint using JavaScript and X-Auth-Token, but I am continuously encountering errors. The data is from a sports API, and despite diligently following all the instructions in the documentation and checking m ...

Calculating the size of a POST request payload

I have an object that looks like this: { "Id": 1, "Value": 10, "UId" : "ab400" } How can I calculate the length of this object so that I can send it in an ajax request? $.ajax({ url: 'http://example.com/api/data', type:"PO ...

Count the number of records in each group in MySQL by using

Looking for movies that have exactly 4 genres? Consider this: Movies (ID, Genre) The relationship between movies and genres is many-to-many, so an ID does not represent a single genre. To find out how many movies have exactly 4 genres, you can use the fo ...

Modify the contents of three div elements by incorporating JavaScript and ajax techniques

Currently working with rails 4 and JavaScript, I am faced with the following dilemma: I want to be able to alter the content of 3 specific divs on my page by clicking a single button. The values in these divs are being created by a Ruby function located in ...

Details on SQL Server Report Builder in the Parameter Pane

Can we customize the parameter pane to display specific information based on the user's selection? I envision a functionality where users can choose a store from the dropdown list, and upon selection, they are presented with details such as the store ...

Having trouble converting svg to png, thinking it might be due to discrepancies in svg elements

I am facing a puzzling issue where two different SVG elements are causing my JavaScript to work in one scenario but not the other. I have replaced the SVG elements in both examples, and surprisingly, only one works while the other does not. You can view th ...

Upon logging in to the first HTML page, the user will be automatically redirected to the second HTML page while passing values

Is there a way to automatically redirect users to Login2.html when selecting "TEAM" in the dropdown on Login1.html, using the values entered in Login1.html? Similarly, can we redirect them to the Premium page when they select "Premium"? I need a solution u ...

Progressing in a connected sequence of changes on a linear graph with distinct points and a pause

A jsfiddle has been created here. Looking to move a circle along a sine wave graph, triggered by a click event. The circle should stop at specific x and y value pairs on the graph before moving to the last point and looping back to the first (ideally unti ...

What is the process of generating a statement for a List<object>?

I have a code snippet using List<object> as shown below: List<object> Result= new List<object>(); Some SQL connection code... SqlCommand com = new SqlCommand(@" Select TOP(10) a,b,c from table More SQL connection code... while (rd.Re ...

Identify the invalid field within an Angular form

After the form is rendered, I need to identify which fields are not valid after 5 seconds. Currently, I have a button that is set as ng-disabled="!step1Form.$valid". However, I would like to add a CSS class, possibly in red, to highlight the invalid fields ...

Modal not opening when activated from Foundation Foundation

I am encountering difficulty in triggering the Reveal modal, and I cannot figure out the issue. Initially, I suspected a JavaScript conflict. To troubleshoot, I stripped down the site to its essentials: some CSS, some JS, and some HTML. However, even afte ...

The typeof operator is not functioning as anticipated when used with an ajax response

Trying to implement form validation using AJAX and PHP, but encountering issues with the typeof operator. The validation works smoothly except when receiving an empty response, indicating that all fields have passed. In this scenario, the last input retai ...

"Enhancing Collaboration with NextJs Multi-Zones' Unified Header

Currently, I have two applications named admin-shell and delivery-management, both of which are being managed using Multi Zones in NextJs. These applications share a common header with navigation links, but I am encountering difficulties navigating betwee ...

CORS error occurs when making an AJAX request to a SpringBoot controller

I am having trouble passing a JSON object to my controller using AJAX. The issue I am facing is a CORS error that reads as follows: Access to XMLHttpRequest at ........ from origin 'null' has been blocked by CORS policy: Response to prefligh ...

What is the proper way to use Object.entries with my specific type?

On my form, I have three fields (sku, sku_variation, name) that I want to use for creating a new product. I thought of converting the parsedData to unknown first, but it seems like a bad practice. export type TProduct = { id: string, sku: number ...

Having trouble with Node.js multiparty upload functionality

I'm facing an issue with the functionality of multiparty.Form(). Specifically, I am attempting to print numbers like 2, 3, and 4. Below is the code snippet for uploading images: app.post('/gallery/add',function(req, res,next) { var input = ...

Adding additional information to the end of a table using JQuery

<table id="myTable0" name="myTable0"> <tbody> <tr> </tr> </tbody> </table> <table id="myTable1" name="myTable1"> <tbody> <tr> </tr> </tbody> </table> I am seeking a solution in JQuer ...

Mapping an array of objects using dynamically generated column names

If I have an array of objects containing country, state, city data, how can I utilize the .map method to retrieve unique countries, states, or cities based on specific criteria? How would I create a method that accepts a column name and maps it to return ...

Using HTML to showcase various prompt messages based on the screen resolution

For the button click event, when clicked on desktop screens it will show a prompt message saying 'Hi'. On the other hand, when clicked on mobile screens, the prompt message displayed will be "Hello". ...

Conditional statement in Javascript for document.cookie

I am attempting to create a basic if statement that relies on the value of a cookie. The function looks like this: function setHomePage() { if ($.cookie('settingOne') == 'jjj') { $('.secO').css('display', & ...