Styjun

Averting Bathos

Can I see the total amount of my crafting materials?

practicality of 30 year fix mortgage at 55 years of age

Global Frame of Reference in General Relativity

What benefits does the Power Word Kill spell have?

Can my former employer sue me if I don't give them the photos I took (taking pictures was not part of my job description)?

Why was LOGO created?

Why is 6. Nge2 better, and 7. d5 a nessecary push in this game?

Excel Solver linear programming - Is it possible to use average of values as a constraint without #DIV/0! errors or sacrificing linearity?

A file manager to open a zip file like opening a folder, instead of extract it by using a archive manager

Why does my browser attempt to download pages from http://clhs.lisp.se instead of viewing them normally?

Why does this image of Jupiter look so strange?

What should I consider when deciding whether to delay an exam?

Why is a road bike faster than a city bike with the same effort? & how much faster it can be?

Why are there two fundamental laws of logic?

Sort by contiguous digits as a single number

I am 15 years old and do not go to a Yeshiva but would like to learn Talmud. A few rabbis near me said they could teach me. How should I start

Reorder a matrix, twice

Golf (6-card) Golf!

What would influence an alien race to map their planet in a way other than the traditional map of the Earth

Best way to visualize huge amount of data

What are ATC-side procedures to handle a jammed frequency?

A food item only made possible by time-freezing storage?

Is there a way to hide HTML source code yet keeping it effective?

Hot to fix : not connected error when execution the sql statement, DPI-1010:not connected?

SQLite - UPSERT *not* INSERT or REPLACESimulating group_concat MySQL function in Microsoft SQL Server 2005?How can I get useful error messages in PHP?Select n random rows from SQL Server tableHow do you create a temporary table in an Oracle database?“where 1=1” statementSQL Server Case Statement when IS NULLHow do I debug “Error: spawn ENOENT” on node.js?Node js oracle module: the console log statement not working when select query is executedconsole.log doesn't work when there's an error later in the function

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

enter image description hereWhen i execute sql statement in nodeJs, it tells me there is an error like this !
what will be the possible solutions ?

 connection.execute("create table testmm (city varchar(10));", function(err, res) 
 if(err) 
 console.error(err);
 
 else 
 console.log("LLLLLL");
 console.log(res);
 
 );][1]

sql node.js oracle error-handling node-oracledb

share|improve this question

edited Mar 28 at 18:40

Abdelrahman AL-Sawalmeh

asked Mar 28 at 17:32

Abdelrahman AL-SawalmehAbdelrahman AL-Sawalmeh

3066 bronze badges

add a comment
 | 

0

enter image description hereWhen i execute sql statement in nodeJs, it tells me there is an error like this !
what will be the possible solutions ?

 connection.execute("create table testmm (city varchar(10));", function(err, res) 
 if(err) 
 console.error(err);
 
 else 
 console.log("LLLLLL");
 console.log(res);
 
 );][1]

sql node.js oracle error-handling node-oracledb

share|improve this question

edited Mar 28 at 18:40

Abdelrahman AL-Sawalmeh

asked Mar 28 at 17:32

Abdelrahman AL-SawalmehAbdelrahman AL-Sawalmeh

3066 bronze badges

add a comment
 | 

enter image description hereWhen i execute sql statement in nodeJs, it tells me there is an error like this !
what will be the possible solutions ?

 connection.execute("create table testmm (city varchar(10));", function(err, res) 
 if(err) 
 console.error(err);
 
 else 
 console.log("LLLLLL");
 console.log(res);
 
 );][1]

sql node.js oracle error-handling node-oracledb

share|improve this question

edited Mar 28 at 18:40

Abdelrahman AL-Sawalmeh

asked Mar 28 at 17:32

Abdelrahman AL-SawalmehAbdelrahman AL-Sawalmeh

3066 bronze badges

 connection.execute("create table testmm (city varchar(10));", function(err, res) 
 if(err) 
 console.error(err);
 
 else 
 console.log("LLLLLL");
 console.log(res);
 
 );][1]

share|improve this question

edited Mar 28 at 18:40

Abdelrahman AL-Sawalmeh

asked Mar 28 at 17:32

Abdelrahman AL-SawalmehAbdelrahman AL-Sawalmeh

3066 bronze badges

share|improve this question

edited Mar 28 at 18:40

Abdelrahman AL-Sawalmeh

asked Mar 28 at 17:32

Abdelrahman AL-SawalmehAbdelrahman AL-Sawalmeh

3066 bronze badges

asked Mar 28 at 17:32

Abdelrahman AL-SawalmehAbdelrahman AL-Sawalmeh

3066 bronze badges

asked Mar 28 at 17:32

Abdelrahman AL-SawalmehAbdelrahman AL-Sawalmeh

3066 bronze badges

1 Answer
1

active

oldest

votes

0

You're trying to connect to the SYSTEM account - don't do that unless you're doing admin work. If you want to create your own tables, then create an application user/schema and then connect as that user.

I see you're working with a local database. Are you able to connect to it from SQL*PLUS or SQL Developer as the SYS user? If so, you can use that to unlock the SYSTEM account. Once that's done you can connect as either SYS or SYSTEM to create the new user. Here's an example script to do that:

create user my_app identified by oracle 
default tablespace users
temporary tablespace temp;

grant connect to my_app;
grant resource to my_app;

grant create view to my_app;

After running that, you can update your code to use the new user's credentials to connect an create your table.

Finally, when you go to execute your SQL statement, remove the trailing semicolon or you'll get another error.

share|improve this answer

answered Mar 28 at 19:20

Dan McGhanDan McGhan

1,36611 gold badge88 silver badges88 bronze badges

add a comment
 | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55403703%2fhot-to-fix-not-connected-error-when-execution-the-sql-statement-dpi-1010not%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You're trying to connect to the SYSTEM account - don't do that unless you're doing admin work. If you want to create your own tables, then create an application user/schema and then connect as that user.

I see you're working with a local database. Are you able to connect to it from SQL*PLUS or SQL Developer as the SYS user? If so, you can use that to unlock the SYSTEM account. Once that's done you can connect as either SYS or SYSTEM to create the new user. Here's an example script to do that:

create user my_app identified by oracle 
default tablespace users
temporary tablespace temp;

grant connect to my_app;
grant resource to my_app;

grant create view to my_app;

After running that, you can update your code to use the new user's credentials to connect an create your table.

Finally, when you go to execute your SQL statement, remove the trailing semicolon or you'll get another error.

share|improve this answer

answered Mar 28 at 19:20

Dan McGhanDan McGhan

1,36611 gold badge88 silver badges88 bronze badges

add a comment
 | 

0

You're trying to connect to the SYSTEM account - don't do that unless you're doing admin work. If you want to create your own tables, then create an application user/schema and then connect as that user.

I see you're working with a local database. Are you able to connect to it from SQL*PLUS or SQL Developer as the SYS user? If so, you can use that to unlock the SYSTEM account. Once that's done you can connect as either SYS or SYSTEM to create the new user. Here's an example script to do that:

create user my_app identified by oracle 
default tablespace users
temporary tablespace temp;

grant connect to my_app;
grant resource to my_app;

grant create view to my_app;

After running that, you can update your code to use the new user's credentials to connect an create your table.

Finally, when you go to execute your SQL statement, remove the trailing semicolon or you'll get another error.

share|improve this answer

answered Mar 28 at 19:20

Dan McGhanDan McGhan

1,36611 gold badge88 silver badges88 bronze badges

add a comment
 | 

You're trying to connect to the SYSTEM account - don't do that unless you're doing admin work. If you want to create your own tables, then create an application user/schema and then connect as that user.

I see you're working with a local database. Are you able to connect to it from SQL*PLUS or SQL Developer as the SYS user? If so, you can use that to unlock the SYSTEM account. Once that's done you can connect as either SYS or SYSTEM to create the new user. Here's an example script to do that:

create user my_app identified by oracle 
default tablespace users
temporary tablespace temp;

grant connect to my_app;
grant resource to my_app;

grant create view to my_app;

After running that, you can update your code to use the new user's credentials to connect an create your table.

Finally, when you go to execute your SQL statement, remove the trailing semicolon or you'll get another error.

share|improve this answer

answered Mar 28 at 19:20

Dan McGhanDan McGhan

1,36611 gold badge88 silver badges88 bronze badges

create user my_app identified by oracle 
default tablespace users
temporary tablespace temp;

grant connect to my_app;
grant resource to my_app;

grant create view to my_app;

share|improve this answer

answered Mar 28 at 19:20

Dan McGhanDan McGhan

1,36611 gold badge88 silver badges88 bronze badges

answered Mar 28 at 19:20

Dan McGhanDan McGhan

1,36611 gold badge88 silver badges88 bronze badges

answered Mar 28 at 19:20

Dan McGhanDan McGhan

1,36611 gold badge88 silver badges88 bronze badges