Styjun

What is the difference between an astronaut in the ISS and a freediver in perfect neutral buoyancy?

Duplicate Tuples in two different ways

Would you write key signatures for non-conventional scales?

Windows 10 deletes lots of tiny files super slowly. Anything that can be done to speed it up?

Top off gas with old oil, is that bad?

"I will not" or "I don't" in the following context?

How to stop the death waves in my city?

I reverse the source code, you reverse the input!

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

Basing my protagonist on myself

What does Sartre mean by "pédéraste" - pederast or homosexual?

Does "as soon as" imply simultaneity?

Do wheelchair-accessible aircraft exist?

Another student has been assigned the same MSc thesis as mine (and already defended)

Convex hull in a discrete space

End a command question

I transpose the source code, you transpose the input!

Seventh degree polynomial

What secular civic space would pioneers build for small frontier towns?

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

Can I enter the UK without my husband if we said we'd travel together in our visa application?

Why isn't there armor to protect from spells in the Potterverse?

Is the iPhone's eSim for the home or roaming carrier?

Difference between "rip up" and "rip down"

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