logs archiveIRC Archive / Freenode / #oracle / 2010 / May / 30 / 1
SilSila
what is the latest patch for 10gR2 db? is it 10.2.0.4? or any other?
TheBonsai
PSU 4 iirc, yes. check metalink, there's an overview note (recommended patches)
SilSila
i tried to search in metalink but i failed
TheBonsai
lemme check if i have it in my bookmarks
check 756671.1
SilSila
what is the difference between patch and patchset? which i have to apply for my db? patchset is showing 10.2.0.5.0 see the note 8202632
TheBonsai
ah yea, 10.2.0.5 was released, yes
anyways, a patch is a patch for one specific issue, a PSU is a collection of recommended patches
many patches applyable in one run
SilSila
here anybody working in oracle application server. because when i am collecting details for migrating our client/server to web enabling...i have finalised with (((oracle developer 6 ==> oracle forms & reports 10gR2 in Oracle Application Server 10.2.0.2 will be in RHEL 4.8))) and (((from oracle 9iR2 db ==> oracle 10gR2 db will be in RHEL 4.8))) because of the compatibility i have selected this combination...is it possible to migrate like this... (((oracle develop
ech0s7
hi
what is the difference between like and = operator '
?
drdimitri
ech0s7 With like you can use wildcards
         

ech0s7
ok i have found on documentation
thanks anyway
drdimitri: it's possible to use wildcards also for integer ?
for example
select * from person where id = %
drdimitri
Only if you convert the int value to a char bevor: where to_char(int_col) like '123%'
ech0s7
ok
drdimitri
Of course oracle cannot use an index any more if you do this, or you have to create a function based index.
peterKaleta
hi
how can i chage error language in sqlplus?
*change
Trengo
google for nls_lang
peterKaleta
Trengo - i changed it in win registry for my db home , should i change it eanywhere else ?
Trengo
win registry? its an env var...
peterKaleta
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410553
ok i got it
thank you
Trengo
great :)
i actually prefer the env var thing to editing bloody registry
peterKaleta
I usually work on mac , but oracle is king of creepy there so i must work on win
Btw do you know why I cannot run create or replace package and create or replace package body in one sql file ?
it throw s me aerror
*an error
Trengo
sure you can
end the commands with ; and add a / at the end of the file?
peterKaleta
wait a sec i will past you this error
yes tehere were ; and /
"/" should be after each block or only at the end ?
Trengo
only at the end
peterKaleta
hmm it runned ok this time
after creating package with procedures should i do something more to be abble to use it (using with its owner user )
Trengo
no, thats fine
peterKaleta
i got SP2-0734: unknown command beginning
even if im putting it in a BEGIN END
while running between BEGIN and END i got : PLS-00221: 'TEST_FUNC' is not a procedure or is undefined
Trengo
you have to call it as package.procedure
execute package.procedure('param');
peterKaleta
It is a function , maybe i need just to assign it
i can run package rpocedure with no problem, functions are generating this errors
Trengo
select package.function('param') from dual;
         

peterKaleta
i will try
it was problem with assignment
anyway thank you for help :)
LongBeach
does anyone use GIT for versioning ?
Trengo
LongBeach i do, but in a very odd way
LongBeach
how ?
Trengo
its a website
whenever the developers send a patch, i apply it and then git the whole tree
it simply enables me reversing a bad patch without the need for restoring a backup
« prev next »