Script will not run in sql.

[shackdavid]

Good day, I have been using a sql. database and associated scripts which I inherited from a previous user.
This database and scripts has been running on a WINXP machine for years without issue.
Oracle Database 10g Express Edition has been used and we access database via the web browser, IE.

I have tried to move over to a WIN 7 machine as the database is accessed by a win32 program.

I keep getting a red screen when I try to run the script, the script is as follows:

--
-- Purpose : Create the default tablespace for the NEMAS DB user
-- Usage : @create_tablespace <filename_with_complete_path>
--
CREATE TABLESPACE "NEMAS"
DATAFILE 'c:\nemas\nemas.dbf'
SIZE 100M REUSE
DEFAULT STORAGE
(
INITIAL 104K
NEXT 104K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
);

Please help.

 

[r4nd0m]

Don't know my PL/SQL too well, but why is everything on a single line? Is it ignoring your newlines?

Because essentially everything is one big comment then.

Also you have more code executing than what you pasted. The error could be in the other portion.

 

[Kosmik]

Good day, I have been using a sql. database and associated scripts which I inherited from a previous user.
This database and scripts has been running on a WINXP machine for years without issue.
Oracle Database 10g Express Edition has been used and we access database via the web browser, IE.

I have tried to move over to a WIN 7 machine as the database is accessed by a win32 program.

I keep getting a red screen when I try to run the script, the script is as follows:

--
-- Purpose : Create the default tablespace for the NEMAS DB user
-- Usage : @create_tablespace <filename_with_complete_path>
--
CREATE TABLESPACE "NEMAS"
DATAFILE 'c:\nemas\nemas.dbf'
SIZE 100M REUSE
DEFAULT STORAGE
(
INITIAL 104K
NEXT 104K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
);

Please help.

Single lines are a pain. Not sure on Oracle but check that you have :

1. Rights to create databases
2. The folder has allowed write permissions to the instance running security context.

 

[Nod]

In which editor have you edited the script?
Seems like a line termination issue (\n vs \n\r).

 

[shackdavid]

So when I run the script in WINXP via the brower it works.


When i run in Win 7 via the same browser, i get red screen (error) why ?

 

[Kosmik]

So when I run the script in WINXP via the brower it works.

View attachment 869937
When i run in Win 7 via the same browser, i get red screen (error) why ?

Could be a browser issue. Set compatibility to ie 7 or compatibility mode in ie and see if makes a difference. As others have said, it appears in a single line in the one and correctly set in the other. Your second actually has line no's etc which is missing from the first so I suspect the control is not compatible, nothing wrong with the script.

 

[shackdavid]

Thanks alot Kosmik, setting I.E. 11 to compatibility mode solved this issue.

Happy day.

 

[Kosmik]

Thanks alot Kosmik, setting I.E. 11 to compatibility mode solved this issue.

Happy day.

Cool, I suggest you find a new browser control though or another means, it's obviously on its last legs.

 

[Nod]

Thanks alot Kosmik, setting I.E. 11 to compatibility mode solved this issue.

Happy day.

It seems that IE 11 have an issue with line wrapping in text areas.

Internet Explorer 11 word wrap is not working

It seems that word wrapping no longer works for textarea elements in IE 11. In IE 10 and earlier, FF, Safari, and Chrome word wrapping works as expected. IE 11 is not implementing any word wrappin...

stackoverflow.com

Is it working in a proper browser (FF/Chrome)?