Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Update statistics after creation of index

1723552Aug 4 2014 — edited Aug 5 2014

Hi,

Version : 11g

Will oracle update the statistics after creation or modification of index ?

Thanks.

This post has been answered by Zoltan Kecskemethy on Aug 4 2014
Jump to Answer

Comments

164043
Ricardo, you can do that from CURL extension. You can set options via curl_setopt and
retrieve it with curl_multi_getcontent. Here is the man page:

http://hr.php.net/manual/en/ref.curl.php

Good luck.
I'll track down someone in the CRM on Demand group and get some background. But as I understand it at the moment, everything is available as a webservice, and the wsdl files are available on http://download.oracle.com/docs/cd/E14004_01/books/CRMWeb.zip Googling will give plenty of online references about using PHP to consume web services.

Documentation is at http://download.oracle.com/docs/cd/E14004_01/books/CRMWeb/CRMWeb81TOC.html
(The documentation portal with these references is at http://download.oracle.com/docs/cd/E14004_01/homepage.htm )
679538
Thanks, I reviewed the links, please, Can you give me some examples of how connect to CRM On Demand with PHP?
164043
I cannot speak for Chris but connecting to web server is essentially the same, regardless of the service provided by the web server. CURL and some parsing is what I would do in your position. Of course, I am not in your position.
164043
You can also use http_request PEAR package. The documentation is here:
http://pear.php.net/manual/en/package.http.http-request.php
751573
This is in PHP and will return the session ID.

$this->crmdomain points to your URL.

function login() {

$url = $this->crmdomain . "/Services/Integration?command=login";
$page = "/Services/Integration?command=login";
$headers = array("GET ".$page." HTTP/1.0",
"UserName: YOUR USERNAME",
"Password: YOUR PASSWORD",
);

$this->ch = curl_init();
curl_setopt($this->ch, CURLOPT_URL,$url);
curl_setopt($this->ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($this->ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($this->ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($this->ch, CURLOPT_SSL_VERIFYHOST, FALSE);
curl_setopt($this->ch, CURLOPT_HEADER, true);
$data = curl_exec($this->ch);


if (!curl_errno($this->ch)) {
$SessionId = substr($data,(strpos($data,"Set-Cookie:")+23),(strpos($data,";")-strpos($data,"Set-Cookie:")-23));
curl_close($this->ch);
return $SessionId;
} else {
return(0);
}

}//endof
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 2 2014
Added on Aug 4 2014
13 comments
92,703 views