SO : windows xp
database : XE
there is a table (transito) with two fields of clob datatype. in a plsql code, there is an update statement in this table. but those columns (clob datatypes) are not in this statement as below :
update transito
set auto_validado = 1
,regra_auto_validacao = 4
where exportado = 0
and auto_validado = 0
and ( emergencia = 1
or tipo in (2, 3, 4)
or tipo is null
or resultado in (1, 3, 4)
or resultado is null
);
all of the columns (auto_validado, regra_auto_validacao, exportado, tipo and resultado) are number datatype.
the clob's columns are : justificativa_resultado and tp_tag.
when this statement is executed, the ora-00932 is raised.
any help ?
thanks
Parse error: parse error in C:wampwwwlogspagesmembers.php on line 16
I dont see the problem with this, I always get Parse error: parse error in C:\wamp\www\logs\pages\members.php on line 16, what did I do wrong?? <?php $sql = "SELECT *
ClientScript.RegisterClientScriptBlock Issue
This is what I haveview plaincopy to clipboardprint?Protected Sub posrback_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles posrback.Click
PHP Redirecting
Hello everyone. Is there a way to redirect people to pages within a statement in PHP? Since there is output before this redirect i cant use the header function.Thnx for your time
Array help
Hello i got this code to fetch data from database but it is not working it displays7ArrayArrayArrayArrayArrayArrayCode: if (isset($_POST['showrecord'])){ $query='SELECT * FROM artus_test';
Loosing changed contents when used FM REUSE_ALV_GRID_DISPLAY
Hi,
for loop without same $i digits?
Hi, Can some guru please advise how can I accomplish this with a simple for loop ? I want to use for loop to echo all number from 000 to 999Quotefor($i=0;$i<1000;$i++){echo "$i";}My
Upload, SSL and more php help
I recently just installed a ssl cert and do i use https for the whole site or just for the checkout.php and cart.php and login.php files?whats the proper way to use https?I have 2 more questions, when
SAP FICO learning materials
Hi all,
check if value exists
I have googled this for a while and I am getting lots of different results. Is there a standard method used for checking to see if a value exists in a database before inserting a value? I have a form,
2 decima places & How to reload my page
Hello There,How do i put full-stop (.) after second figure from behind? ie if i have 123456 in my database and i want it to echo as 1234.56Secondly, am designing a shopping website. I want the pages
