Question: when i post ajax, error occurs.
[![enter image description here](https://i.stack.imgur.com/rzwuw.png)](https://i.stack.imgur.com/rzwuw.png)
these are my codes.

```
let xhr = new XMLHttpRequest()
let data ={
      "name": "test",
      "phone": "12345678",
      "email": "test@test.com",
      "content": "i wish"
    }
let dataStr = JSON.stringify(data)
xhr.open('post',apiUrl,true) // apiUrl is provided from back side
xhr.setRequestHeader('Content-type','application/json')
xhr.send(dataStr)

```

it has bothered me few days,please help me.

Answer: 
No translation is needed. Simply re-run the same query. Python and Excel VBA serve as client applications that connect to the same backend database, here being Oracle. Databases are designed to connect to *any* client.

In fact, consider saving your long SQL query in a text `.sql` file and have all clients simply read the script file and avoid long strings with quote enclosures or line breaks in either code.

**Python**

```py
conn= cx_Oracle.connect('...')

# READ SQL QUERY FROM FILE
with open(r'C:\path\to\my\query.sql') as f:
    query = f.read().strip()

# IMPORT INTO PANDAS DATA FRAME
try:
    df = pd.read_sql(con = conn, 
                     sql = query)     # QUERY READ FROM .sql FILE
finally:
    conn.close()

df.head()

```

**Excel VBA**

```vb
' READ SQL QUERY FROM FILE
With CreateObject("Scripting.FileSystemObject")
      sql = .OpenTextFile("C:\Path\To\my\query.sql", 1).readall
End With

' OPEN DB CONNECTION
Set conn = New ADODB.Connection
conn.Open "..."

' DEFINE COMMAND OBJECT
Set cmd = New ADODB.Command
With cmd
    .ActiveConnection = conn
    .CommandType = adCmdText
    .CommandText = sql               ' QUERY READ FROM .sql FILE

    Set rst = cmd.Execute
End With 

```
The query will be the same. In both cases it is sent to the DB to execute and return the data. Because the text contains single quotes, you will want to wrap it with triple double-quotes (") instead of the triple single-quotes that you have around the SELECT \* FROM DUAL.