Oracle

Oracle Community

NOTE: This forum is for non-product questions and discussions on the Oracle database platform.
 
Please post Toad-family product questions in their respective product forums.  Thanks!

Community Discussion

CFig
Follow / 28 Jan 2015 at 9:33pm / Oracle
Latest post by on 24 Feb 2015 at 2:01pm

systimestamp in PL/SQL

Expand content
When I select a function of systimestamp(1) into c7, all is well. When I assign c7 := a function of systimestamp(1) , I get an error PLS-000306. See code below: PQRPSB01> l 1 declare c7 varchar2...

When I select a function of systimestamp(1) into c7, all is well.  When I assign c7 := a function of systimestamp(1) , I get  an error PLS-000306.  See code below:

PQRPSB01> l

  1  declare c7 varchar2(9);

  2  begin

  3  select trim(to_char(systimestamp(1),'hh24missff')) into c7 from dual;

  4  --c7 :=  trim(to_char(systimestamp(1),'hh24missff')) ;

  5  dbms_output.put_line(c7);

  6* end;

PQRPSB01> /

1609119

 PL/SQL procedure successfully completed.

 PQRPSB01> /

1609138

PL/SQL procedure successfully completed.

PQRPSB01> edit

Wrote file afiedt.buf

   1  declare c7 varchar2(9);

  2  begin

  3  --select trim(to_char(systimestamp(1),'hh24missff')) into c7 from dual;

  4  c7 :=  trim(to_char(systimestamp(1),'hh24missff')) ;

  5  dbms_output.put_line(c7);

  6* end;

PQRPSB01> /

c7 :=  trim(to_char(systimestamp(1),'hh24missff')) ;

                    *

ERROR at line 4:

ORA-06550: line 4, column 21:

PLS-00306: wrong number or types of arguments in call to 'SYSTIMESTAMP'

ORA-06550: line 4, column 1:

PL/SQL: Statement ignored

PQRPSB01>

 Can somebody explain why?

Thanks,

Carl

164 3 / Create an account to join the discussion.
ecelebi@ciu.edu.tr
Follow / 23 Feb 2015 at 12:14pm / Oracle

Academic Licence

Expand content
Hi, I am an instructor at an university, and I am intended to use Oracle for DBMS II course. So I need Toad for Oracle to be installed on the laboratory computers for the students. How can I download...

Hi,

I am an instructor at an university, and I am intended to use Oracle for DBMS II course. So I need Toad for Oracle to be installed on the laboratory computers for the students. 

How can I download the academic version rather than the freeware.

Best Regards

46 0 / Create an account to join the discussion.
parthipanmurali
Follow / 16 Feb 2015 at 11:02am / Oracle
Latest post by on 16 Feb 2015 at 9:25pm

oracle

Expand content
when i have start oracle 12c database using sql developer but it shows initialization or shutdown in progress . any one help me come over the error??????

when i have start oracle 12c database using sql developer but it shows initialization or shutdown in progress. any one help me come over the error??????

Unanswered 83 1 / Create an account to join the discussion.
mhungu.muridzo
Follow / 16 Feb 2015 at 6:55am / Oracle
Latest post by on 16 Feb 2015 at 5:16pm

Oracle 11g Undo tablespace filling up exponentially

Expand content
I have an oracle database 11g, there is a daily process that I run that is filling up the undo tablespace exponentially to 3.6 GB before the used space comes down to below 10 MB and the tablespace size...

I have an oracle database 11g, there is a daily process that I run that is filling up the undo tablespace exponentially to 3.6 GB before the used space comes down to below 10 MB and the tablespace size will remain at 3.6 GB way above the initial size of 500 MB. I have 3 redo log groups sized at  100 MB each. My question is what leads to that exponential space usage in my undo tablespace? Please assist.

95 1 / Create an account to join the discussion.
Aftab Ahmad
Follow / 21 Nov 2014 at 2:06am / Oracle
Latest post by on 13 Feb 2015 at 5:06am

Database_Creation

Expand content
As we know ,we can create a database by method DBCA,OMF and MANUALLY, I want to know there is any another method to create a database and also I want to know what is advantage

As we know ,we can create a database by method DBCA,OMF and MANUALLY, I want to know there is any another method to create a database and also I want to know what is advantage

206 1 / Create an account to join the discussion.
mistre83
Follow / 12 Feb 2015 at 12:21pm / Oracle

Performance with FOR IN

Expand content
Hi to all,. there are difference in term of performance using a FOR IN (select ....) instead of CURSOR with the same query and using OPEN CURSOR/FETCH ?

Hi to all,.

there are difference in term of performance using a FOR IN (select ....) instead of CURSOR with the same query and using OPEN CURSOR/FETCH ?

72 0 / Create an account to join the discussion.
Crazyforcubes
Follow / 11 Feb 2015 at 8:37pm / Oracle

Can I write MDX queries on Toad for Oracle?

Expand content
Hello, I am new to Toad, Can I write MDX queries on Toad for Oracle Base 11.5? If Yes, any settings to be made? If no then which toad software will allow me to write MDX queries? Thanks for your...

Hello,

I am new to Toad, Can I write MDX queries on Toad for Oracle Base 11.5?

If Yes, any settings to be made? If no then which toad software will allow me to write MDX queries?

Thanks for your help.

-Aakash

74 0 / Create an account to join the discussion.
Norm [TeamT]
Follow / 7 Feb 2015 at 2:30pm / Oracle

Re: Session shows red in color in Session browser in Toad 11.6

Expand content
Afternoon "tkdba", the session you see in red, in Toad's session browser, is the one Toad is using to access the database to show you the current sessions and what they are doing. ...
Afternoon "tkdba",

the session you see in red, in Toad's session browser, is the one Toad
is using to access the database to show you the current sessions and
what they are doing.

So, looking at that session will show you what Toad is doing in order to
monitor sessions.

HTH


Cheers,
Norm. [TeamT]

On 29/01/15 08:15, tkdba wrote:
> *Session shows red in color in Session browser in Toad 11.6
> *
> Thread created by tkdba
>
> In the above snapshot, SID 919 shows red in color but i can see no
> difference in this SID 919 when compared to other active session.
>
> But why only this is red in color and this is the first time am seeing
> this red in color. Whenever we enable trace on the particular session, i
> knew that it shows green in color.
>
> Can anyone explain why this SID 919 in above snapshot shows red in color.
>
> Thanks,
>
> TK
>
> To reply, please reply-all to this email.
>
> Stop receiving emails
>
> on this subject.
> Or Unsubscribe from Oracle
>
> notifications altogether.
> Toad World - Oracle Discussion Forum
>
> Flag
>
> this post as spam/abuse.
>
>


--
Cheers,
Norm. [TeamT]
50 0 / Create an account to join the discussion.
PRAKASH VERMA
Follow / 26 Jan 2015 at 8:13pm / Oracle

How to Get Index Value of an Element of Nested Table

Expand content
I create a nested table, then populated this nested table. I have some question on above table which are following : 1. now i want to get index value of a particular element of nested table like...

I create a nested table, then populated this nested table.

I have some question on above table which are following :


1. now i want to get index value of a particular element of nested table

like what is the index value of JONES who is in ENAME Column of EMP_NTAB Nested table.

2. I need to update the Job of JONES Only.

Note - File is attached 

Unanswered 91 0 / Create an account to join the discussion.
jdaniel1127
Follow / 12 Jan 2015 at 1:51am / Oracle

oracle 10G to 11G

Expand content
trying to move an Oracle 10G production system to a new 11G system. Installed 11G on a test box, then created tablespaces and copied data/index files. then tried expdp full=y, expdp content=metadata_only...

trying to move an Oracle 10G production system to a new 11G system. Installed 11G on a test box, then created tablespaces and copied data/index files. then tried expdp full=y, expdp content=metadata_only, expdp content=data_only ( only get the data for the user I login as.  I wouldn't think it should be that hard to get 10G to 11G...

downloaded toad in hopes it will help with this process.

Unanswered 131 0 / Create an account to join the discussion.
linuxshop
Follow / 9 Jan 2015 at 1:10pm / Oracle

How to enable the data guard Icon in spotlight on oracle 9.0

Expand content
I have configured a Data guard enviroment using ORACLE 11G R2 11.2.0.3.0, and we can use spotlight on oracle to connect to Oracle database. but the spotlight on oracle cannot know the enviroment of data...

I have configured a Data guard enviroment using ORACLE 11G R2 11.2.0.3.0, and we can use spotlight on oracle to connect to Oracle database.

but the spotlight on oracle cannot know the enviroment of data guard,and the tool icon of data guard is disabled.

what's the condition to activate the data guard icon?

Unanswered 136 0 / Create an account to join the discussion.
h.alzeini
Follow / 7 Jan 2015 at 1:45am / Oracle

Quest Error Manager Freeware v1.4.1 missing documentation

Expand content
Hi, I've downloaded Quest Error Manager Freeware v1.4.1 to implemente in my PL/SQL packages. A very brief idea found in the author's book . In the downloaded folder, there is html file and help...

Hi, 

I've downloaded Quest Error Manager Freeware v1.4.1  to implemente in my PL/SQL packages. A very brief idea found in the author's book  . In the downloaded folder, there is html file and help file but these are empty. They look like this:

Is this what should I expect or there is something missing here? 

In fact, I cannot use the package as numerous procedures inside, do not have documentation to know what the parameteres we need to pass to them and how to fetch their values ... etc. I'd deeply appreciate it if someone can point out where can I find the documentation/examples/reference for this package.

Unanswered 215 0 / Create an account to join the discussion.
jahanzaibniazi001
Follow / 26 Dec 2014 at 12:57am / Oracle
Latest post by on 29 Dec 2014 at 10:04pm

Error in PL/SQL bubble sorting program

Expand content
i am writing a plsql bubble sorting program but it is giving a error "ORA-06532: Subscript outside of limit" kindly help me to resolve it as i am new to plsql DECLARE temp int; type first is...

i am writing a plsql bubble sorting program but it is giving a error "ORA-06532: Subscript outside of limit"     kindly help me to resolve it as i am new to plsql



DECLARE

temp int;
type first is VARRAY(6) of integer;
arr first;
i integer;
j integer;
BEGIN
i:=0;
j:=1;
temp:=0;
arr:=first(3,1,4,2,5,9);
FOR i in 0..4 LOOP
FOR j in 1..5 LOOP
if arr(i)>arr(j) then
temp:=arr(i);
arr(i):=arr(j);
arr(j):=temp;
end if;
END LOOP;
END LOOP;
FOR i in 0..5 LOOP
dbms_output.put_line(arr(i));
END LOOP;

END

228 1 / Create an account to join the discussion.
nitin.gautam
Follow / 23 Dec 2014 at 1:44am / Oracle

Compare Data with Join

Expand content
I have two tables table A and B. Table A have some plan information including ID and NAME of plan. PLAN_NAME is the unique value. Table B have some rules configured for assignment of those plans...

I have two tables table A and B.

Table A have some plan information including ID and NAME of plan. PLAN_NAME is the unique value.

Table B have some rules configured for assignment of those plans and using plan Id. One plan can have many rules.

I have to compare the data in another database for same tables, but plan Id can be differ only PLAN_NAME is matching.

I am using Data Compare feature of Toad but not sure how to do this compare as I need to compare all plan rules for a PLAN_NAME...not sure if we can join in where clause while compare with Data compare featrure...or some other effective way available?

171 0 / Create an account to join the discussion.
tyler.beets
Follow / 5 Dec 2014 at 5:10pm / Oracle
Latest post by on 5 Dec 2014 at 8:07pm

Error Log function and exception. PLS-00201

Expand content
I'm trying to create an error log table that displays package name, function name, error message, and a timestamp. EXCEPTION WHEN OTHERS THEN ERROR_MSG := SUBSTR(SQLERRM, 1, 100); INSERT INTO ERROR_LOG...

I'm trying to create an error log table that displays package name, function name, error message, and a timestamp. 

EXCEPTION

WHEN OTHERS THEN
ERROR_MSG := SUBSTR(SQLERRM, 1, 100);

INSERT INTO ERROR_LOG (PACKAGE_NAME, FUNCTION_NAME, ERROR_MESSAGE, ERROR_TIMESTAMP, USER_ID)
VALUES ('USER_PKG', 'INSERT_FUNCT', ERROR_MSG, CURRENT_TIMESTAMP);

It's saying ERROR_MSG must be declared by I'm not sure how to do that

232 1 / Create an account to join the discussion.